How to get pagination in Teradata..??

Analytics

How to get pagination in Teradata..??

How 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..
1 REPLY
Enthusiast

Re: How to get pagination in Teradata..??

In TD we cant get the rows based on the row number,we have some functions like Top,sample you can try these two
but if you want to take out based on the row number.You can strategize your loading of the particular table by inserting a row number as an additional field .You can assign row number by using the analytical functions row_number,rank