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

0 vote271 views1 answer
Storing RGBA in mysql db
SQL
0 vote292 views1 answer
Psql store procedure-return multiple table values
SQL
0 vote262 views1 answer
Sqlite referential integrity
SQL
4 votes264 views1 answer
To date oracle with time
SQL
6 votes274 views1 answer
Check Table Exists
SQL
1 vote265 views1 answer
Sql delete all values in a column
SQL
8 votes268 views1 answer
Mac restore mysql database command line
SQL
0 vote272 views1 answer
Postgres in operator with comma separated values
SQL
0 vote272 views2 answers
The metadata storage is not up to date, please run the sync-metadata-storage command to fix this issue.
SQL
1 vote311 views1 answer
Sql how to replace full stop
SQL