How to select the top 10 rows from a table

KevinYC · #1 (**permalink**) 11-13-08, 11:29

Hello all,

I know you can select the top 10 records from a table in SQL server with the following:

select top 10 *
from tb123

Is there a similar command in DB2?

Thanks!

ARWinner · #2 (**permalink**) 11-13-08, 12:22

select * from tb123 fetch first 10 rows only

Andy

madhu_kaza · #3 (**permalink**) 11-13-08, 12:54

SELECT * FROM <table name>
FETCH FIRST N ROWS ONLY

Thanks
Madhavi.

KevinYC · #4 (**permalink**) 11-13-08, 14:38

Thank you both !

Internet Services

Web Development

Digital Marketing

Consumer Tech