Javatpoint Logo
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




Please Share

facebook twitter google plus pinterest tumbler

Learn Latest Tutorials