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 vote239 views2 answers
Login to mysql
SQL
0 vote174 views1 answer
Sql cross apply vs join
SQL
11 votes230 views5 answers
Laravel db facade
SQL
0 vote217 views1 answer
Mysql join only one column
SQL
13 votes201 views2 answers
Get tables in database sql
SQL
0 vote201 views1 answer
Java sql timestamp now
SQL
0 vote211 views1 answer
Sql on-premises
SQL
0 vote205 views1 answer
Laravel migration sql dump
SQL
0 vote160 views1 answer
Procedures and functions in pl/sql
SQL
12 votes208 views5 answers
Sql primary key
SQL