SQL SELECT FIRST

SQL select first query with sql, tutorial, examples, insert, update, delete, select, join, database, table, join

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:

SELECT FIRST(column_name) FROM table_name;

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:

SELECT FIRST(customer_name) AS first_customer FROM customers;

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

Table CUSTOMERS

CUSTOMER_NAME	AGE	ADDRESS	EXPENDITURE
KAMAL SHARMA	26	GHAZIABAD	6000
ROBERT PETT	23	NEWYORK	26000
SHIKHA SRIVASTAV	22	DELHI	9000

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:

SELECT FIRST (CUSTOMER_NAME) AS first_customer FROM CUSTOMERS;  
After that query, you will find the result:
KAMAL SHARMA

.NET Array Dictionary List String 2D Async DataTable Dates DateTime Enum File For Foreach Format IEnumerable If IndexOf Lambda LINQ Parse Path Process Property Regex Replace Sort Split Static StringBuilder Substring Switch Tuple

Core Array ArrayList HashMap String 2D Cast Character Console Deque Duplicates File For Format HashSet If IndexOf Lambda Math ParseInt Process Random Regex Replace Sort Split StringBuilder Substring Switch Vector While

TheDeveloperBlog.com