select * from table_name fetch first 3 rows only;

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

Question Posted / hemachandar

4 Answers
8239 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

Please Help Members By Posting Answers For Below Questions

what is db2 restart?

2213

What is bind package and plan in db2?

1109

What is dpf in db2?

1167

How do you stop a db2 database in linux?

1058

What is the role of union all and union

1187

What is the picture clause of null indicator variable?

1183

What is consistency token in db2?

1194

How do I add a column to a table in db2?

1157

How to take backup of table in db2?

1121

What is db2 plan table?

1110

What is page size in db2?

1027

When a COBOL-DB2 program in PRODUCTION is updating main tables and gone for long run, what have to do?

3637

What is db2 catalog database?

1091

Explain about rct in db2?

1163

What is buffer pool in the db2 database?

1157