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

0 vote185 views2 answers
Mysql dump database tables only
SQL
2 votes177 views1 answer
Add new column not null sql server
SQL
8 votes203 views2 answers
Default sql server port
SQL
0 vote168 views1 answer
How to check replication lag in mySQL
SQL
1 vote180 views2 answers
Extract weekday from date in sql
SQL
7 votes160 views2 answers
Create index mysql
SQL
0 vote199 views1 answer
Mysql get first 2 characters of string
SQL
1 vote165 views1 answer
Index a database column sql
SQL
1 vote175 views1 answer
Moodle query item quiz
SQL
2 votes184 views1 answer
Mysql id of inserted row
SQL