17-Feb-2022
.
Admin
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...
#MySQL