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 : shy-seal-rpgytmlovlcu

SELECT TOP 1 * FROM Table ORDER BY ID DESC

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

Answered by : strange-skunk-jr1odmoemnfw

select * from tbl_name order by id desc limit N;

Source : https://stackoverflow.com/questions/4193705/sql-server-select-last-n-rows | Last Update : Sun, 19 Jun 22

Answered by : vastemonde

SELECT (SELECT * FROM tableName ORDER BY col1 LIMIT 1) AS first, (SELECT * FROM tableName ORDER BY col1 DESC LIMIT 1) AS last
;

Source : https://stackoverflow.com/questions/1485391/how-to-get-first-and-last-record-from-a-sql-query | Last Update : Tue, 27 Apr 21