Archives of the TeradataForum

Message Posted: Thu, 11 May 2006 @ 08:29:11 GMT


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

Subj:		Re: The first lines for the result of a request

From:		Victor Sokovin

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

          > Select TOP 10 userid, Sum(TotalCPUTime) cpu
          > From dbc.DBQLogTbl
          >
          > Group By 1;


Try to run this query first:

     select * from dbc.dbcinfo;



If you see that VERSION is set to something like 05.xx.xx.xx then that is what we call database release 2 (you will hardly see any other
release anywhere so this number is always the same, don't worry about it), version 5. As other posters have already noted you need to be on
version 6 to enjoy the TOP function. My guess is that you are not there as yet.

Alternatively, you can take a look at the RELEASE entry. It will be set to V2R.06.xx.xx.xx if you are on version 6.

It is always good to know which version of the database you are currently working on and you might include it in your posting when you have
specific questions on syntax, usage etc because these things can be version specific.


Regards,

Victor

 
 
 
 


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

Attachments

Library

Quick Reference