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 vote181 views1 answer
How to print longest name in sql
SQL
28 votes177 views4 answers
Mysql delete database
SQL
0 vote198 views1 answer
Sql quary stuf
SQL
0 vote167 views1 answer
SQLite3::SQLException: table "categories" already exists: CREATE TABLE "categories" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL
SQL
0 vote144 views1 answer
Sql runnignsum
SQL
0 vote181 views1 answer
Sql sum show 0 result
SQL
0 vote175 views1 answer
Mysql database hyphen
SQL
1 vote193 views3 answers
Psql fatal database does not exist
SQL
0 vote163 views1 answer
Django how to get query result count
SQL
0 vote147 views1 answer
Jooq finding lastest value in table
SQL