Need to get my assignment done for SQL

Job ID: 32937808

Budget: $15 – $25 CAD

Get the second highest salary for each department in four different queries;

1. Subquery
2. Cross apply
3. Corelative subquery
4. Window function

Related categories: SQL MySQL Database Administration Microsoft SQL Server