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 happens in bind step in a db2 program?
Mention some fields that are a part of sqlca.
What is a storage group (stogroup)?
What is query_cache_limit?
What are the rules for db2 programming?
What is phantom read in db2?
i want to maintain uniqueness on pdf without make lf??????????
Comment whether dclgen is mandatorily used. If not, then what is the point of using it?
Explain various types of locks in db2?
What is the difference between bind and rebind in db2?
Explain db2.
What is isolation level in db2?
What is the cobol picture clause of the db2 data types date, time, timestamp?
What is the use of commit in db2?
What is null value in db2?
