EX Squared Interview Question

Find the Kth highest salary from employees table using SQL

Interview Answer

Anonymous

Aug 27, 2024

Select DISTINCT salary from employees order by DESC LIMIT 1 OFFSET K;

1