By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,756 Members | 1,721 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,756 IT Pros & Developers. It's quick & easy.

DB2 in mainframe

P: 1
Ho w to select the first 10 records in IBM DB2 in mainframe?

I used the below mentioned query but it throws an error

select top 10 * from tablename;

The error msg thrown is as follows

"Invalid identifier as 10".

Can you please provide the solution?
Feb 24 '07 #1
Share this Question
Share on Google+
1 Reply


P: 1
Uma you can try the below query

select * from tablename fetch first 10 rows only;

-Raja
Feb 27 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.