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 vote295 views1 answer
Mysql select all and rename one
SQL
6 votes246 views2 answers
Spring data jpa application.properties mysql
SQL
1 vote268 views1 answer
Create sample data postgresql
SQL
0 vote231 views1 answer
Mysql collation for all languages
SQL
0 vote307 views1 answer
Oracle sql how to overcome 999 limit for IN
SQL
0 vote273 views1 answer
Postgresql update to unique
SQL
0 vote292 views1 answer
Flask sqlalchemy session delete
SQL
1 vote313 views1 answer
What is in condition in sql
SQL
0 vote288 views3 answers
Postgresql grant alter table to user
SQL
0 vote285 views1 answer
Merge clause with inner join
SQL