Informatica Interview Question

Query to fetch 3rd largest salary from table. stack vs heap allocation. Puzzles. Deadlock Questions.