Teradata Forums / Analytical Applications / Teradata / equivalent of rownum in td / Latest PostsInstantForum.NET v4.1.4Teradata Forumshttp://www.teradata.com/teradataforum/info@teradata.comSat, 06 Sep 2008 20:35:51 GMT20RE: equivalent of rownum in tdhttp://www.teradata.com/teradataforum/Topic11385-5-1.aspxselect top n columnlist from tablename;where n is the number of rows you want.not sure how, but it works.Fri, 25 Jul 2008 12:51:27 GMTmapsiddiquiRE: equivalent of rownum in tdhttp://www.teradata.com/teradataforum/Topic11385-5-1.aspxHi Jack,it's ROW_NUMBER() OVER (ORDER BY ...)Btw, Oracle also supports that RW_NUMBER.DieterThu, 08 May 2008 10:51:06 GMTdnoethRE: equivalent of rownum in tdhttp://www.teradata.com/teradataforum/Topic11385-5-1.aspxhi jack,I believe you want to use rownum to limit the number of rows retrieved. as far as i know, there is no system column in teradata to do this, but one can generate a column like a seq_num to retrieve specific interval of rows. if the order is not required, you can use SAMPLE to return a specific number of rows, though randomly.sel * from this wil return 10 rows selected randomly.thx,Thu, 08 May 2008 10:13:16 GMTSNequivalent of rownum in tdhttp://www.teradata.com/teradataforum/Topic11385-5-1.aspxCan you tell me what is equivallentof rownum in teradata in oracle I can useselect rownum,ename from empWhat is its equivalent query in teradata?Thu, 08 May 2008 09:05:07 GMTJACKSON