Select last row mysql

Mysql get last row

SELECT fields FROM table ORDER BY id DESC LIMIT 1;

Select last row mysql

SELECT
  (SELECT * FROM tableName ORDER BY col1 LIMIT 1)        AS first,
  (SELECT * FROM tableName ORDER BY col1 DESC LIMIT 1)   AS last
;

Source: stackoverflow.com

Mysql select last 10 rows

SELECT * FROM tableName ORDER BY col1 DESC LIMIT 10;

Select first and last row mysql

(select *from DemoTable694 order by EmployeeId ASC LIMIT 1)
UNION
(select *from DemoTable694 order by EmployeeId DESC LIMIT 1);

How to fetch data from database without last column

SELECT lastName,firstName FROM Customer
       WHERE lastName LIKE "B%"
         AND city = "Indianapolis"
         AND (phone LIKE "%8%" OR fax LIKE "%8%")

Source: dummies.com

Similar codes

0 vote275 views1 answer
Select amount weeks between two dates mysql
SQL
2 votes269 views1 answer
Sql create database
SQL
0 vote312 views1 answer
Python mysql check if database exists
SQL
10 votes249 views2 answers
Mysql select timestamp group by day
SQL
53 votes538 views6 answers
How to install mysql ubuntu
SQL
0 vote267 views1 answer
Sql insert tuple
SQL
0 vote272 views1 answer
Utiliser sql ligne de commande
SQL
5 votes286 views2 answers
Create function postgresql
SQL
7 votes295 views2 answers
MySQL IF without else
SQL
4 votes260 views2 answers
Sql select except null
SQL