Pergunta de entrevista da empresa RS Software

Query to get n-th highest salary from Employee table. Total salary for different dept. Views, Triggers Difference between Procedure and Function.