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

22 votes169 views3 answers
Sql cheat sheet
SQL
0 vote169 views1 answer
Sql select lowest value row
SQL
0 vote170 views1 answer
Postgresql remove new line from string
SQL
8 votes176 views1 answer
Unique vs primary key
SQL
1 vote165 views1 answer
Search for tables with name postgresql
SQL
0 vote208 views1 answer
Snowflake drop column
SQL
0 vote220 views1 answer
Dialect undefined does not support db:create / db:drop commands
SQL
0 vote200 views1 answer
Buscar nombre de columna en todas las tablas sql server
SQL
6 votes165 views2 answers
Database url postgres
SQL
0 vote199 views1 answer
SQLServerException.makeFromDatabaseError
SQL