Interested to Buy Any Domain ? << Click Here >> for more details...
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 the role of union all and union
what is db2 restart?
Give the name of some fields form sqlca.
Where can you declare a cursor in a cobol-db2 program?
What is database manager in db2?
My sql statement select avg(salary) from emp yields inaccurate results. Why?
How and when does the db2 enforces the unique key?
Can you use max on a char column?
What are the contents of a dclmgen?
What are iseries servers?
Which are the db2 tools to protect integrity of the database?
Explain the function of data manager.
What is db2 connect?
What are the full forms of spufi and dclgen and why are they used?
How does coalesce work?
