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

-1 vote127 views1 answer
Default username and password for oracle 11g
SQL
3 votes129 views2 answers
Monthname sql
SQL
0 vote129 views1 answer
Mssql unique key accept nulls
SQL
-1 vote127 views2 answers
Import data from excel to sql server automatically
SQL
0 vote135 views1 answer
Java nosql sort
SQL
0 vote114 views1 answer
Mysql group by derived column
SQL
24 votes103 views2 answers
Alter table delete column
SQL
36 votes122 views3 answers
Finding duplicate column values in table with sql
SQL
0 vote128 views2 answers
What is the default password for sql server sa
SQL
150 votes200 views10 answers
Grepper
SQL