TEKsystems Interview Question

1. write a SQL query to identify the employee with second largest salary 2. write a query to remove duplicate records in a table 3. explain SCD type 2 mapping