How to Get First Row of Table in MySQL?

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: