TOP
Top  Previous  Next

This parameter includes the support to specify the TOP n qualifier for the SELECT command. The TOP n will retreive the top number of records from the table.

select_top


The "TOP n" goes between the word SELECT and the column list for the command.


Example:

To show the top 5 bonuses where the bonus is under $500 from SalesBonus table in ConComp:

SELECT TOP 5 * FROM SalesBonus WHERE Bonus < 500 ORDER BY Bonus=DESC