Get only first row mysql

/**
To return only one row use LIMIT 1:
**/

SELECT *
FROM tbl_foo
WHERE name = 'sarmen'
LIMIT 1

/**
It doesn't make sense to say 'first row' or 'last row' unless you have an ORDER BY clause.
Assuming you add an ORDER BY clause then you can use LIMIT in the following ways:
To get the first row use LIMIT 1.
To get the 2nd row you can use limit with an offset: LIMIT 1, 1.
To get the last row invert the order (change ASC to DESC or vice versa) then use LIMIT 1.
**/

Source: stackoverflow.com

Similar codes

0 vote267 views1 answer
Sql date with year
SQL
0 vote239 views1 answer
How to select only the first rows for each unique value of a sql tablecolumn?
SQL
0 vote209 views1 answer
How do i calculate someone's age based on a datetime type birthday?
SQL
0 vote254 views1 answer
How do you insert boolean to postgresql
SQL
0 vote182 views1 answer
Microsoft sql server management studio clear cache
SQL
4 votes237 views1 answer
Change nls_date_format
SQL
8 votes232 views1 answer
Declare table variable sql server
SQL
0 vote228 views1 answer
Postgresql log
SQL
0 vote258 views1 answer
Const pool = mysql.createpool()
SQL
1 vote241 views2 answers
Oracle list service names
SQL