Archives of the TeradataForum

Message Posted: Fri, 24 Jan 2014 @ 08:59:00 GMT

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

Hi Sughesh,

You SQL always returns one row irrespective of its value ( 0 or more) in that.

Use the below SQL

     Select 1
       from table_Name
       where 
       having count(0) > 1;

The above SQL does not return anything in case the result is zero.

Thanks

Mohankumar

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