next → ← prev

MySQL first function

The MySQL first function is used to return the first value of the selected column. Here, we use limit clause to select first record or more.

Syntax:

SELECT column_name
FROM table_name
LIMIT 1;

MySQL first function example

To SELECT FIRST element:

Consider a table named "officers", having the following data.

mysql first() 1

Execute the following query:

SELECT officer_name 
FROM officers
LIMIT 1;

Output:

mysql first() 2

To SELECT FIRST two records

SELECT officer_name 
FROM officers
LIMIT 2;

Output:

mysql first() 3

Next TopicMySQL last

← prev next →

We provides tutorials and interview questions of all technology like java tutorial, android, java frameworks

Contact info

G-13, 2nd Floor, Sec-3, Noida, UP, 201301, India

[email protected].

Follow us

Tutorials

Java Data Structures C Programming C++ Tutorial C# Tutorial PHP Tutorial HTML Tutorial JavaScript Tutorial jQuery Tutorial Spring Tutorial

Interview Questions

Tcs Intuit Wipro Adobe Infosys Amazon Accenture Cognizant Capgemini Microsoft

Online Compiler

C R C++ Php Java Html Swift Python JavaScript TypeScript

© Copyright 2024 Javatpoint. All Rights Reserved.