- Printer-friendly version
- Log in to post comments
In this shosrt post we will show how to obtain the N first rows from a Query on IBM DB2.
With Oracle SQL would be with ROWNUM, and with SQL Server we'd use TOP.
This is the Top 10 query syntax:
select * from My_Table fetch first 10 rows only