Javatpoint Logo

91-9990449935

 0120-4256464

Javatpoint Logo

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:

EMP_IDNAMESIR_NAMEUSER_NAME
1RAHULOJHAra@jha
2ANUSHARMAanusha1
3RAVISINGHALravin

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:

EMP_IDNAMESIR_NAMEUSER_NAME
1RAHULOJHAra@jha
2ANUSHARMAanusha1
Next TopicSQL Select First




Latest 4 Tutorials on JavaTpoint