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
8077 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 to check last update on table in db2?

1050

What is a buffer in memory?

1055

Explain package in db2 and its advantages?

1202

What is the use of db2?

1047

What is the difference between db2 and oracle?

1118

What is the reason behind not using select * in embedded sql programs?

1100

What is a Foreign Key?

1091

What is runstats db2?

1013

What is a bind in db2?

1037

What is dclgen in db2?

1137

what is diffrence b/w file-aid tool and file-aid utility???

4886

What is catalog database in db2?

1156

What is dclgen (declaration generator)?

1050

What are foreign keys in db2?

1098

Can we update view in db2?

995