SQL SELECT TOP

The SQL SELECT TOP Statement is used to select top data from a table. The top clause specifies that how many rows are returned.

Let's see an example. If a table has a large number of data, select top statement determines that how many rows will be retrieved from the given table.

There is an example of employee table:

Let's see the syntax for the select top statement.

Let's see the example of sql select top statement.

It will return the following table: