DataEngPrep.tech
QuestionsBlogStore
Get PDF Bundle

Interview Questions

Real questions from top companies in SQL

700+ Easy450+ Medium650+ Hard
All CategoriesBehavioralSpark/Big DataSQLPython/CodingSystem Design/ArchitectureCloud/ToolsGeneral/Othereasymediumhard
41

Write an SQL query to find duplicate emails in a users table.

SQLmediumpartitionsqlwindow0.5 min read
Daniel WellingtonGoldman SachsSwiggy
→
42

Triggers in ADF, especially tumbling window triggers.

SQLmediumpartitionwindow0.5 min read
AccentureYash Technologies
→
43

What is a CTE (Common Table Expression)? What are its uses?

SQLeasybigquerysnowflake0.6 min read
Fossil GroupKaseya
→
44

What is a window function? Explain with an example.

SQLmediumjoinpartitionwindow0.5 min read
CitiFreecharge
→
5

What is the difference between OLTP and OLAP?

SQLmedium
6

Write a SQL query to find top 3 earners in each department.

SQLmedium
7

Write a query to find the top three highest-paid employees in each department using window functions.

SQLmedium
8

Write complex SQL queries involving multiple joins, subqueries, and data aggregation logic.

SQLmedium
9

Add Row Numbers using window function in PySpark

SQLmedium
10

Add a column to the Employees table that shows the name of the employee with the next higher employee_id.

SQLmedium
11

Add a new column with manager names for each employee using a self-join.

SQLmedium
12

Add a new column with the average salary by department.

SQLmedium

+16 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.

Get PDF Bundle — from $21Try Free Sample
Previous12345...25Next