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
8113 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 do I delete a table in db2?

1074

What is rebind in db2?

1069

What is host variable in db2 cobol?

1078

What is the max length of sqlca?

1216

List some fields from sqlca?

1060

What is load replace in db2?

996

How to fetch the last row from the table in SQL (db2)?

1657

What is a page in db2?

1027

What does runstats do in db2?

1120

Explain what are the various isolation levels possible?

1044

How do I delete a column in db2?

1109

What is an instance in db2?

1036

What is deadlock in db2?

1070

What is dpf in db2?

1111

what is db2 restart?

2162