Remove duplicate records and find 5th highest salary department wise using SQL.

• Use DISTINCT keyword to remove duplicate records.

• Use GROUP BY clause to group the records by department.

• Use ORDER BY clau...read more