Archives of the TeradataForum

Message Posted: Thu, 22 Mar 2012 @ 20:39:54 GMT

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

TD13 Windows XP

I ran below SQL and it fails with this error, "SELECT failed. 3706: Syntax error: expected something between an integer and the 'select' keyword." I wonder what to change. Thank you,

     SELECT top 255 select  Value, count(*)
      from ( select Value from ABC.def sample 500000 )  as group by 1 order by 2 desc;

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