Javatpoint Logo

91-9990449935

 0120-4256464

Javatpoint Logo

SQL SELECT FIRST

The SQL first() function is used to return the first value of the selected column.

Let's see the syntax of sql select first() function:

Here a point is notable that first function is only supported by MS Access.

If you want to retrieve the first value of the "customer_name" column from the "customers" table, you need to write following query:

Let us take the example of CUSTOMERS to examine SQL SELECT FIRST command:

Table CUSTOMERS

CUSTOMER_NAMEAGEADDRESSEXPENDITURE
KAMAL SHARMA26GHAZIABAD6000
ROBERT PETT23NEWYORK26000
SHIKHA SRIVASTAV22DELHI9000

If you want to retrieve the first value of the "customer_name" column from the "customers" table, you need to write following query:

Let's see the syntax of sql select first() function:

Note: The SELECT FIRST statement is only supported by MS Access. This statement doesn?t work with other databases like Oracle, MySQL etc.

Next TopicSQL Select Last




Latest 4 Tutorials on JavaTpoint