Archives of the TeradataForum

Message Posted: Mon, 24 Sep 2012 @ 16:54:03 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

     Select *
     From tablename
     Minus
     Select *
     From tablename
     Where number is null
     And value = '1'

Kyle Prescott
DBA Manager
Unum-GHDS
Chattanooga, TN

	<Prev	Next>		<<First	<Prev	Next>	Last>>