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 vote338 views1 answer
How to put value in parameters in mysqldataadapter
SQL
0 vote327 views1 answer
Drop all tables in azure sql database
SQL
3 votes314 views1 answer
V$session not found in oracle
SQL
0 vote387 views1 answer
Sql trim whitespace
SQL
2 votes360 views1 answer
Use cases condition in sql query laravel
SQL
0 vote326 views1 answer
Mysql trim characters
SQL
2 votes352 views1 answer
Datetrunc
SQL
1 vote336 views1 answer
Spring postgresql reset auto increment to 0
SQL
0 vote328 views1 answer
Console output pl sql
SQL
1 vote349 views1 answer
Sql server: query to find out all the places where the table is used
SQL