How to get pagination in Teradata..??
Teradata Teradata Discussion Forums Teradata.com Discussion Forum
Visit Teradata.com
Home   
Search
    Guidelines    Member List
Welcome Guest ( Login | Register )
     
Recent Posts
   
Popular Topics

Teradata Discussion Forums » Teradata » Analytical Applications » How to get pagination in Teradata..??
This online forum is for user-to-user discussions of Teradata products, and is not an official customer support channel for Teradata. If you require direct assistance, please contact Teradata support.


How to get pagination in Teradata..?? Expand / Collapse
Rate Topic
Display Mode
Topic Options
Author
Message
RRVARMA
Posted 4/20/2008 10:02:26 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: Forum Members
Last Login: 7/15/2008 11:49:46 AM
Posts: 3, Visits: 15
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..




Thanks,
RRVARMA
Post #11262
GogulM
Posted 4/30/2008 4:46:19 AM
Forum Member

Forum MemberForum MemberForum MemberForum MemberForum MemberForum MemberForum MemberForum Member

Group: Forum Members
Last Login: 4/30/2008 4:36:46 AM
Posts: 32, Visits: 14
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

Regards,

GogulM
Post #11329
« Prev Topic | Next Topic »


Reading This Topic Expand / Collapse
Active Users: 0 ( 0 guests, 0 members, 0 anonymous members )
No members currently viewing this topic.


All times are GMT -5:00, Time now is 2:46pm

Powered By InstantForum.NET v4.1.4 © 2008
Execution: 0.594. 8 queries. Compression Disabled.