Find the 2nd highest salary for each department using the DENSE_RANK() function.
SQLmedium
2
Find the third-highest salary for each department.
SQLmedium
3
Finding nth Highest Salary within each department
SQLmedium
4
Given a CSV file with raw customer transactions, design an ETL pipeline that cleans data, aggregates total sales by region and product, and loads into target table
SQLhard
5
Given a table of sales data, use window functions to calculate a running total.
SQLmedium
6
Given an unoptimized query execution plan, how would you diagnose and improve performance?
SQLmedium
7
Handle nulls, duplicates, and inconsistent timestamp formats in data.
SQLmedium
8
How can you delete partitions from a table in Hive using a command?
SQLmedium
+20 More Questions with Expert Answers
Get the complete 1,800+ question library with detailed, expert-level answers covering SQL, Spark, System Design, Python, Cloud, and Behavioral topics.