To get highest n values from a table in Teradata

In Teradata, you can get the highest 'n' values by the following ways.

For example, if you want to select the highest 10 employee numbers in a table tbl_employee.

Way 1:

SELECT TOP 10 emp_no FROM tbl_employee
ORDER BY emp_no DESC;


Way 2:

SELECT emp_no  FROM tbl_employee QUALIFY ROW_NUMBER() OVER (ORDER BY emp_no DESC) <=10;