TOP Keyword

The TOP <Count> clause allows you to set the maximum number of rows in the query result. To accomplish this you must specify the keyword TOP in the query description, followed by the required number of lines.

The first rows will be shown (according to the ordering rules for query results).

<Count> is always an integer.

 

Example:

// You want to select five most expensive goods.
// The selection must be descending by goods price.

SELECT TOP 5
Catalog.Nomenclature.Description,
   Catalog.Nomenclature.ProcurementPrice

ORDER BY
   Catalog.Nomenclature.ProcurementPrice DESC

Query result:

Name	Purchase Price
Krups food processor	15 000
Women's jeans	1 500
"Cowboy" shirt	1 100
Children's pants	800
"Ultra" mixer	460