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

8 votes256 views2 answers
Default sql server port
SQL
0 vote218 views1 answer
Cannot insert duplicate key in object 'dbo.Instructor'. The duplicate key value is (2).
SQL
0 vote248 views1 answer
Mysql get nested records
SQL
0 vote203 views1 answer
Stuff in sql server
SQL
2 votes213 views1 answer
SQLSTATE[HY000] [1049] Unknown database
SQL
1 vote219 views2 answers
Sql example query
SQL
0 vote209 views1 answer
Query to get all primary keys and foreign key
SQL
1 vote210 views1 answer
Real world example of nosql
SQL
0 vote236 views1 answer
Add created and updatedAt fields in mysql
SQL
0 vote221 views2 answers
How to get last inserted id in sql server c#
SQL