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 vote259 views1 answer
SQL query to verify the size of the table
SQL
0 vote138 views1 answer
Query for maximum salary
SQL
1 vote167 views1 answer
Oracle undo usage per session
SQL
0 vote171 views1 answer
Get all jobs if salary more than 5500 less than 10000 sql
SQL
0 vote226 views1 answer
Migrations.RunSQL
SQL
1 vote175 views1 answer
How to fetch alternate records from two tables
SQL
3 votes131 views1 answer
System.debug apex
SQL
0 vote185 views2 answers
Jsonb
SQL
0 vote167 views1 answer
Parent: [Error: SQLITE_READONLY: attempt to write a readonly database] {
SQL
0 vote190 views1 answer
Plsql check how much space all databases are consuming
SQL