To find the last 5 records, use the ORDER BY clause with a descending order and limit the result to 5. To find unique records, use the DISTINCT keyword.

• To find the last 5 records, use the ORDER BY cla...read more

Select * from ( select emp.*, rownum from emp order by rownum desc) where rownum <=5;

Select * from ( select emp.*, rownum from emp order by rownum desc) where rownum <=5;

Select * from ( select emp.*, rownum from emp order by rownum desc) where rownum <=5;

Select * from ( select emp.*, rownum from emp order by rownum desc) where rownum <=5;

select * from (select * from <table_name> order by rownum desc) where rownum <=5;

select unique(column_name PK) from <table_name);