Write a SQL query to find the second highest salary in a given department without using the LIMIT clause.
Use the employees table and the department value Claims for this exercise. Treat tied salaries as one salary level.
second_highest_salary.| Column | Type | Description |
|---|---|---|
| employee_idPK | INT | Unique employee identifier |
| employee_name | VARCHAR(100) | Employee name |
| department | VARCHAR(50) | Employee department |
| salary | NUMERIC(12,2) | Annual employee salary |