DB2 query to select first or last N rows

DB2 query to select first or last N rows There may be instances when you wish to select first or last N rows. You can use the following query to limit the number of rows retreived

SELECT EMP_NAME FROM EMP_TABLE

SELECT EMP_NAME FROM EMP_TABLE