Get last record in sql

How to get last row of table in sql

mysql> select *from getLastRecord ORDER BY id DESC LIMIT 1;

Source: tutorialspoint.com

Get last record in sql

SELECT * FROM TableName WHERE id=(SELECT max(id) FROM TableName);

Source: stackoverflow.com

Select last row in sql

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

Select last row in sql

SELECT TOP 1 * FROM Table ORDER BY ID DESC

Source: stackoverflow.com

Select last row from SQL Table

SELECT * FROM TableName WHERE id=(SELECT max(id) FROM TableName);

Source: stackoverflow.com

How to get last element sql

	Select Distinct names.xyz
       From nameList names
       LEFT JOIN nameList idNum
       ON idNum.xyz > names.xyz AND idNum.xyz IS NOT NULL
       WHERE idNum.xyz IS NULL

Similar codes

23 votes104 views6 answers
ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication protocol requested by server; consider upgrading MySQL client
SQL
18 votes118 views6 answers
Mysql create table
SQL
1 vote123 views2 answers
Mysql update table from another table
SQL
0 vote109 views1 answer
Mysql multiple count
SQL
0 vote114 views1 answer
Mysql update sum same table
SQL
54 votes278 views6 answers
Sql rename column
SQL
11 votes237 views2 answers
Import mysql dump command line windows
SQL
11 votes119 views1 answer
Ddl materialized view
SQL
12 votes115 views4 answers
Mysql version
SQL
0 vote120 views2 answers
List all constraints in postgres
SQL