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 vote120 views1 answer
My sql data file extention
SQL
0 vote140 views1 answer
Ceil upto 2 decimal place mysql
SQL
0 vote115 views1 answer
Mysql disable query caching
SQL
15 votes195 views3 answers
Postgresql change column type
SQL
1 vote129 views2 answers
Insert sqlite
SQL
9 votes132 views3 answers
Import DB through mysql console
SQL
0 vote122 views3 answers
Query string not ending with with vowels
SQL
3 votes106 views2 answers
To_char sql
SQL
0 vote136 views1 answer
Print hello world in plsql
SQL
1 vote124 views1 answer
Oracle sql average
SQL