select * from table_name order by ascending 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 / gummadi

4 Answers
7889 Views
UST, I also Faced
E-Mail Answers

Answer Posted / gummadi

select * from table_name
order by ascending
fetch first 3 rows only

Is This Answer Correct ?

3 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

How is deadlock resolved?

1082

What is the purpose of rollback and commit?

1089

Give a brief description of db2 isolation levels?

1014

What is package in cobol db2?

1078

What is dclgen in db2?

1084

How do I import a csv file into db2?

938

How do you select a row using indexes in db2?

1075

How to resolve deadlock issue

19873

What is the difference between dbm cfg and db cfg file in db2 ?

1481

If the cursor is kept open followed the issuing of commit, what is the procedure to leave the cursor that way?

1093

What is the cobol picture clause of the db2 data types date, time, timestamp?

1012

What is cascading rollback?

1135

What are the 2 sqlcodes that are returned?

1131

Explain packages.

1055

Explain what are the various isolation levels possible?

991