SQL FIRST() FUNCTION

SQL FIRST() Function

The FIRST() function returns the first value of the selected column.

SELECT FIRST(column_name) FROM table_name

We have the following "Orders" table:

Now we want to find the first value of the "OrderPrice" column.

We use the following SQL statement:

SELECT FIRST(OrderPrice) AS FirstOrderPrice FROM Orders

Tip: Workaround if FIRST() function is not supported:

SELECT OrderPrice FROM Orders ORDER BY O_Id LIMIT 1

The result-set will look like this:

FirstOrderPrice

1000