How to Get First Row of Table in MySQL?

MySQL

Nicesnippets

17-02-2022


Hi Friends,

I am going to explain to you an example of how to get the first row of the table in MySQL?. You will learn to find the first row of the table in the SQL query. Inside this article, we will see the get first row in select query.

To return only the first row that matches your SELECT query, you need to add the LIMIT clause to your SELECT statement.

So let's start following example.

Table : users


Solution SQL Query:

SELECT

*

FROM `users`

LIMIT 1

Output:

I hope it can help you...