Archives of the TeradataForum

Message Posted: Wed, 10 May 2006 @ 15:56:17 GMT

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

hi,

my request was like :

     Select userid, Sum(TotalCPUTime) cpu
     From    dbc.DBQLogTbl

     Group   By 1;

My fisrt good results are with :

     Select userid, Sum(TotalCPUTime) cpu
     From    dbc.DBQLogTbl

     Group   By 1
     QUALIFY ROW_NUMBER() OVER (ORDER BY cpu) <= 10;

The use of TOP fonction is not OK ....

     Select TOP 10 userid, Sum(TotalCPUTime) cpu
     From    dbc.DBQLogTbl

     Group   By 1;

I have this error :

     Code = 3706.
     3706:  Syntax error: expected something between the word 'TOP' and the
     integer '10'.

Output directed to Answer set window

Berrafato Jean-Michel

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