Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

please clarify my doubts abt DB2 SQL QUERIES

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
kedarreddy827
Warnings : 1

New User


Joined: 21 Sep 2005
Posts: 5

PostPosted: Tue Dec 13, 2005 12:07 pm    Post subject: please clarify my doubts abt DB2 SQL QUERIES
Reply with quote

1.QUERY for retrieving first N records?


2.QUERY for retrieving first 15th record to 25th record?


3.QUERY for retrieving last record to 15th record? order of retrieval should be
last record
last but one record
......
........
.........
15th record



thank you
kedar
Back to top
View user's profile Send private message

iknow

Active User


Joined: 22 Aug 2005
Posts: 413
Location: Colarado, US

PostPosted: Tue Dec 13, 2005 12:18 pm    Post subject: Re: please clarify my doubts abt DB2 SQL QUERIES
Reply with quote

Hi kedar,

Search our forum. Query1 is been answered already.

Hope this helps.
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Running queries against OLTP Database A_programmers DB2 3 Tue Jul 14, 2015 4:51 pm
No new posts Selective execution of a queries Delip DB2 9 Fri Jan 16, 2015 3:51 pm
No new posts Re-write queries to minimize the effe... Anil Khanna DB2 6 Mon Aug 04, 2014 1:49 pm
No new posts Running multiple queries in a PS file... nikhil_bansal04 JCL & VSAM 12 Wed Dec 18, 2013 12:06 pm
No new posts Mainframe Laguagae Environment Relate... Subramanin,Govindarajan All Other Mainframe Topics 1 Thu Jan 31, 2013 11:15 am


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us