MySQL||How many ways to get last row from a table?
1. LIMIT
SELECT * FROM emp ORDER BY ID DESC LIMIT 1;
2. Sub-Query
SELECT * FROM EMP WHERE id= (SELECT MAX(id) FROM emp);
3. Row_number()
SELECT * FROM
(SELECT *,ROW_NUMBER()OVER(ORDER BY ID DESC) as rn FROM EMP)AS Result
WHERE rn=1
![[FREE] SLIMESITO x BEEZYB TYPE BEAT 2022 -](https://images.videosashka.com/watch/1EoTITwenvE)
