Samantha interviews many candidates from different colleges using coding challenges and…
We define an employee’s total earnings to be their monthly salary* months worked, and…
Samantha was tasked with calculating the average monthly salaries for all employees in…
Generate the following two result sets:
Write a query identifying the type of each record in the TRIANGLES table using…
Given the CITY and COUNTRY tables, query the names of all cities where the CONTINENT is ‘Africa’.
177. Nth Highest Salary
Write a SQL query to get the nth highest salary from the Employee table.
Employee
+----+--------+| Id | Salary |+----+--------+| 1 | 100 || 2 | 200 || 3 | 300 |+----+--------+