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

1 vote121 views1 answer
Strict in postgres SQL
SQL
0 vote156 views1 answer
ACCEPT nome PROMPT on oracle
SQL
3 votes153 views1 answer
Null sql
SQL
1 vote165 views1 answer
DoVerify() must be an instance of Lcobucci\\JWT\\Signer\\Key
SQL
2 votes141 views1 answer
Rails execute sql
SQL
0 vote211 views1 answer
Mysql update table from select on another table
SQL
0 vote157 views1 answer
Get cpu details sql
SQL
2 votes137 views1 answer
Error Code: 1055. Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column \\ which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
SQL
6 votes143 views2 answers
Mysql set primary key
SQL
0 vote132 views1 answer
Dasebase_url-postgres for windows
SQL