Archives of the TeradataForum
Message Posted: Tue, 05 Jul 2005 @ 09:19:00 GMT
In Oracle, we have a rownum (psudo column) that can limit the number of rows being returned from the DB srvr. Is there a equvalent in TD? From what i understand, the BTEQ LIMIT keyword gets all the rows from the Srvr and displays only the LIMITED rows. What Iam exactly interested in is the performance implications of something like ROWNUM. we have used it extensively in places where EXISTS like conditions have to be used in Oracle. Pls comment!
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|