Answer Posted / sree
SELECT * FROM TABLENAME ORDER BY PRIMARYCOLUMNNAME DESC
FETCH FIRST 5 ROWS ONLY ;
THIS ANSWER IS VALID ONLY IF THERE IS A PRIMARY KEY
COLUMN,OTHERWISE IT WONT WORK
IF THERE IS NO PRIMARY KEY COLUMN IN GIVEN TABLE ,I DON'T
KNOW THE ANSWER
FOR FETCHING FIRST 5 ROWS
SELECT * FROM TABLENAME FETCH FIRST 5 ROWS ONLY;
| Is This Answer Correct ? | 8 Yes | 1 No |
Post New Answer View All Answers
what is a corelated subquerry?
What are union and union all?
How do I change the column size in db2?
Why select is not preferred in embedded sql programs?
What is the difference between using bind () and rebind () methods of naming class?
Give the name of some fields form sqlca.
Why db2 is called db2?
What is the meaning concurrency in the db2 database?
What are the full forms of spufi and dclgen and why are they used?
What are the uses of db2 optimizer?
What is the use of commit in db2?
Comment whether dclgen is mandatorily used. If not, then what is the point of using it?
What is a db2 package?
How can you validate Sql errors during cursor operation in db2 pgms and where do you code?
What is multi row fetch in db2?
