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

8 votes170 views1 answer
Oracle search text in all packages
SQL
0 vote157 views1 answer
[object Object]: BY KimbleOne__DeliveryGroup__c, CreatedDate ^ ERROR at Row:1:Column:142 field 'CreatedDate' can not be grouped in a query call
SQL
0 vote158 views1 answer
Oracle webcenter content search enginer
SQL
0 vote177 views1 answer
Synapse sql table set pk
SQL
0 vote150 views1 answer
Sql how to display two atributes as one in sql
SQL
9 votes174 views2 answers
Convert data type in sql
SQL
1 vote173 views1 answer
Sql string function update replace
SQL
0 vote162 views2 answers
Sql server set default value equal to auto increment
SQL
0 vote208 views1 answer
Doctors appointment
SQL
0 vote330 views1 answer
Get first match in each group mysql query
SQL