if there is a table with huge number of records and if i
want to extract only first 3 records from the table, what
query i have to provide to retreive first 3 records
Answer Posted / hemachandar
select * from table_name
fetch first 3 rows only;
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
Mention the various locks that are available in db2.
What is null indicator in db2?
What does reorg do in db2?
is it compulsory commitment control in journal?
What is the function of logging in the db2 database?
If anyone has IBM Certification Dumps pls forward to me & also let me know what are the Certification Codes that are available in DB2
When do you specify the isolation level?
Is db2 free?
What is syscat in db2?
What is bufferpool 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 dpf in db2?
Give the name of some fields form sqlca.
What is the difference between cursor and select statement?
What type of database is db2?