How to get last element sql

How to get last row of table in sql

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

Source: tutorialspoint.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 vote105 views1 answer
How to format tables in sqlplus
SQL
18 votes120 views3 answers
Get the list of all tables in sql server
SQL
2 votes118 views1 answer
Postgresql format date dd/mm/yyyy
SQL
0 vote127 views1 answer
Data directory postgresql
SQL
1 vote122 views1 answer
Change default maximum runtime mariadb from phpmyadmin
SQL
4 votes115 views4 answers
What is primary key
SQL
0 vote123 views1 answer
Node-pre-gyp ERR! Tried to download(403): https://mapbox-node-binary.s3.amazonaws.com/sqlite3/v3.1.13/node-v72-win32-x64.tar.gz
SQL
2 votes107 views1 answer
Mysql trigger after update
SQL
0 vote147 views1 answer
Dialect undefined does not support db:create / db:drop commands
SQL
14 votes125 views4 answers
Online sql compiler
SQL