Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 7914 Views
- UST, I also Faced
- E-Mail Answers
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 is utility for parm lib
How to view db2 table structure?
What is null in db2?
What are bind parameters in db2?
What is db2 stogroup?
What are the contents of a dclmgen?
How to find the number of rows in a db2 table?
What is a trigger in the db2 database?
What is host variable in db2 cobol?
What is bufferpool in db2?
What is the difference between spufi and qmf?
What is the difference between db2 and oracle?
Where can you declare a cursor in a cobol-db2 program?
Describe major components of db2?
What is the reason behind not using select * in embedded sql programs?
