SQL Select First

SQL Select First is used to return first value of selected column.

Take Table name Student

ID Name Age City
1 Rahul 20 Pathankot
2 Karan 24 Mohali
3 Ajay 22 Pathankot
4 Ravi 23 Delhi


Syntax

SELECT FIRST(column_name) FROM table_name;  



SELECT FIRST(`Name`)  FROM Student;  



Output

FIRST(`Name`) Rahul

Back To Top