To fetch last 5 records from a table in SQL

• Use SELECT statement to retrieve data from the table

• Use ORDER BY clause to sort the data in descending order based on a column

• Use LIMIT clause to limit the n...read more

SELECT * FROM table_name ORDER BY id DESC LIMIT 5

select top 5 * from emp order by id desc

Select from( select e.* , dense_rank() over(0rder by <column name> desc) as r from <table name e > where r<=5;