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

10 votes276 views1 answer
Dba_dependencies
SQL
0 vote296 views1 answer
Mysqldump ignore table
SQL
1 vote297 views1 answer
Simple project for database
SQL
3 votes267 views1 answer
System.debug apex
SQL
0 vote298 views1 answer
Sql find all different values in column
SQL
0 vote310 views1 answer
Postgresql linux password
SQL
11 votes316 views5 answers
Update table from another table mysql
SQL
1 vote298 views1 answer
Postgresql create table with timestamp
SQL
0 vote293 views1 answer
Postgresql select fast check no rows
SQL
3 votes334 views1 answer
Oracle sql commit example
SQL