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 db2 stogroup?
What is the physical storage length of the data types date, time, and timestamp?
What is an instance in db2?
Why cursor is used in db2?
Mention the way of highlighting as well as putting a cursor to use in a cobol program.
What is the use of with ur in db2?
What is a dbrm in db2?
I have a subprogram B calling from mainprogram A.I have opened a cursor in A ,Can i fetch the same cursor in subprogram B , If yes , Please explain the reason?
What is ibm db2 connect?
What is collection in db2 bind?
What is the picture clause of null indicator variable?
What is bind in db2?
What is ibm db2 database?
What is meant by explain?
Define data page.
