Select Top Syntax

The "select top" syntax is a syntax used by certain databases to limit the returned rows to the first N rows of a query.

Not all databases support the top keyword in queries. For example, PostgreSQL, MySQL, and SQLite use a limit keyword at the end of the query, Oracle uses a ROWNUM keyword, and Firebird uses a first keyword instead of top. MS SQL Server and Sybase databases do use the top keyword. Below are links with information on how to use select top or the database specific equivalent for various databases: