Answered by : powerful-puffin-14opp8jg6ylm

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

Source : https://www.tutorialspoint.com/how-to-select-last-row-in-mysql | Last Update : Sun, 14 Jun 20

Answered by : bibhukrupa-barik

SELECT * FROM TableName WHERE id=(SELECT max(id) FROM TableName);

Source : https://stackoverflow.com/questions/5191503/how-to-select-the-last-record-of-a-table-in-sql | Last Update : Thu, 05 Aug 21

Answered by : obedient-ocelot-5tkogtygmlyl

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

Source : | Last Update : Thu, 04 Feb 21