The FIRST() function returns the first value of the selected column.
Syntax:-
SELECT FIRST(column_name) FROM table_name;
OR
SELECT column_name FROM table_name ORDER BY column_name ASC LIMIT 1;
Example:-
The subsequent SQL selects the first value of the “VisitorName” column from the “Visitors” table:-

SELECT FIRST(VisitorName) AS FirstVisitor FROM Visitors;

OR

SELECT VisitorName FROM Visitors ORDER BY VisitorID ASC LIMIT 1;

Categories: SQL Function

0 thoughts on “SQL First()”

Leave a Reply

Latest Article

SQL Function

SQL Avg()

The AVG() returns the average value of a numeric column. Syntax:- SELECT AVG(column_name) FROM table_name; Example:- The subsequent SQL gets the average value of the “Price” column from the “Hosting” table:- SELECT AVG(Price) AS PriceAverage Read more…

SQL Function

SQL Count()

The COUNT() returns the number of column or rows that matches a specified criteria. Syntax:- The COUNT(column_name) returns the number of values of the specified column:- SELECT COUNT(column_name) FROM table_name; OR SELECT COUNT(*) FROM table_name; Read more…

SQL Function

SQL Last()

The LAST() returns the last value of the selected column. Syntax:- SELECT LAST(column_name) FROM table_name; OR SELECT column_name FROM table_name ORDER BY column_name DESC LIMIT 1; Example:- The subsequent SQL selects the last value of Read more…