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 vote114 views1 answer
Get table which have specific columns in mysql
SQL
0 vote119 views1 answer
Docker open terminal mysql server
SQL
0 vote118 views1 answer
Mysql insert into select with recursive
SQL
6 votes112 views1 answer
Sql insert values into table
SQL
12 votes107 views1 answer
Psql drop column
SQL
0 vote110 views1 answer
Object Information
SQL
0 vote118 views1 answer
Sql with example
SQL
1 vote115 views1 answer
Search for replace in mysql
SQL
4 votes127 views1 answer
An error occurred while installing pg (1.2.3), and Bundler cannot continue. Make sure that `gem install pg -v '1.2.3' --source 'https://rubygems.org/'` succeeds before bundling.
SQL
0 vote115 views1 answer
Oracle job schedules
SQL