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

14 votes188 views3 answers
Sql trim from string
SQL
2 votes183 views1 answer
Oracle apex list connected users
SQL
18 votes188 views6 answers
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
SQL
0 vote188 views1 answer
TITLE: SQL Server principal "dbo" does not exist
SQL
0 vote188 views1 answer
New rails app with mysql
SQL
0 vote188 views1 answer
Org.apache.spark.sql.avro.IncompatibleSchemaException: Unexpected type org.apache.spark.ml.linalg.VectorUDT
SQL
0 vote148 views1 answer
Import sql file in mysql linux
SQL
0 vote184 views1 answer
Sql case when exists in another table
SQL
0 vote195 views1 answer
Find the names of sailors who have reserved at least one boat
SQL
0 vote202 views1 answer
Google cloud sql postgres url example
SQL