Find the 2nd highest salary for each department using the DENSE_RANK() function.
SQLmedium
262
Find the third-highest salary for each department.
SQLmedium
263
Finding nth Highest Salary within each department
SQLmedium
264
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
265
Given a table of sales data, use window functions to calculate a running total.
SQLmedium
266
Given an unoptimized query execution plan, how would you diagnose and improve performance?
SQLmedium
267
Handle nulls, duplicates, and inconsistent timestamp formats in data.
SQLmedium
268
How can you delete partitions from a table in Hive using a command?
SQLmedium
+20 More Questions with Expert Answers
Unlock all 1,800+ expert answers, AI mock interviews, resume analyzer, SQL playground, and personalized progress tracking.