InstantForum.NET v4.1.4Teradata Forumshttp://www.teradata.com/teradataforum/info@teradata.comFri, 29 Aug 2008 16:32:27 GMT20http://www.teradata.com/teradataforum/Topic11263-9-1.aspxuse rank function and use qualify to choose the results.example:my_customer is a table with cust_no as UPIfirst hundred records can be got by this query:select cust_no, name, rank(cust_no) as row_id from my_customer qualify row_id between 1 and 100;change the row_id as per your requirement.Fri, 09 May 2008 04:29:44 GMTrajanhttp://www.teradata.com/teradataforum/Topic11263-9-1.aspxHow to get pagination in Teradata..?? Its possible in Oracle but is there anyway to get the required amount of exact records in Teradata...?? Actually i need to get first 50 records during my first call to the database and then the next 50 records during my second call.. how is tat possible in Teradata..?? Please help..Sun, 20 Apr 2008 10:04:52 GMTRRVARMA