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
- 4 Answers
- 7258 Views
- UST, I also Faced
- E-Mail Answers
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
What is view db2?
List out the buffer pools in db2
What is cursor with hold option in db2?
What does db2 plan contain?
What is a db2 collection?
Explain about cursor stability?
What is meant by dclgen?
Give a brief description of db2 isolation levels?
What is cursor in dbms?
How can deadlocks be resolved?
What is db2 optimizer?
What is dclgen in db2?
Following a db2 update statement, what is the quickest way to compute the total number of updated rows?
What's The Percentage Free Space ?
How to view db2 table structure?
