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 vote110 views1 answer
GROUP BY postgres
SQL
1 vote99 views1 answer
Mysql count all table rows
SQL
0 vote110 views1 answer
Work around for mutating problem in Oracle Triggers. Please check it out.
SQL
0 vote110 views1 answer
Get foreign table names mysql
SQL
3 votes109 views2 answers
Tsql join multiple record in one string
SQL
0 vote68 views1 answer
Postgresql subquery
SQL
0 vote127 views1 answer
5.Query to raise salary of all employees with 300 in EMP table and display name and salary as new sal from EMP table employee name, job, and salary from EMP table.
SQL
1 vote101 views1 answer
Floor function in sql oracle
SQL
0 vote81 views0 answer
SQL
1 vote108 views1 answer
Where database run
SQL