Pergunta de entrevista da empresa Property Finder

1. Types of Join vs. Union 2. What is Cross Join? 3. Rank vs. Dense_Rank vs. Row_Num 4. Name the window functions. 5. Write a statement and get the second highest salary in the table. 6. Lead, Lag 7. Tableau: Sets vs. Groups