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
8088 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 the latest version of ibm db2?

1263

What is the picture clause of null indicator variable?

1133

Which component is responsible for processing sql statements and selecting access paths?

1125

What is db2 and what is the use of db2 optimizer?

1055

What is plan in cobol db2?

1132

What is lock escalation in db2?

1028

Explain packages.

1107

what are bind concepts in db2 cobol?

1090

What is the meaning concurrency in the db2 database?

1108

How is deadlock resolved?

1146

How would you find out the total number of rows in a db2 table?

1048

What type of database is db2?

965

Define db2.

1104

can all users have the privilage to use the sql statement select * (dml)?

1163

What is a storage group (stogroup)?

1241