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 / andank
SELECT * FROM <qualifier>.<table_name>
FETCH FIRST 3 ROWS ONLY
WITH UR;
The above query holds good, if you are thinking to fetch
rows in any specific order. Otherwise make use of "ORDER
BY".
If you want to filter the records bases on some condition
and fetch first 3 rows, make use of WHERE clause. For
example, if you want to see first 3 records of ACCOUNTS
department, use WHERE DEPTID ='Accounts' FETCH FIRST 3 ROWS
ONLY
Is This Answer Correct ? | 6 Yes | 0 No |
Post New Answer View All Answers
What are catalog tables in db2?
What is ibm db2 connect?
How do I connect my db2 database to ibm?
What is db2 purescale?
What is the difference between spufi and qmf?
What is a db2 cursor?
Name the lockable units in DB2?
What is performance tuning db2?
Define buffer pool.
What is alias in db2?
List out the three types of page locks that can be held.
How can you find out the # of rows updated after an update statement?
Is it possible using max on a char column?
What is difference between alias and synonym in db2?
How to find the number of rows in a db2 table?