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

4 votes360 views1 answer
Oracle error line
SQL
0 vote395 views1 answer
Use mysql in java program
SQL
0 vote341 views1 answer
Select value from previous row in postgresql
SQL
3 votes342 views1 answer
Oracle user privileges
SQL
0 vote371 views1 answer
Sql date time query find
SQL
0 vote435 views1 answer
Mysql show schema
SQL
0 vote378 views1 answer
Mysql collation portugues brasil
SQL
0 vote377 views1 answer
Wordpress delete post revisions older than date "sql"
SQL
0 vote352 views2 answers
Sql query for getting details by id
SQL
0 vote348 views1 answer
Drop all data from tables
SQL