DataEngPrep.tech
QuestionsBlogStore
Get PDF Bundle

Interview Questions

Real questions from top companies · easy

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

Write SQL query to replace specific patterns in a string column.

SQLeasy
2

Write a Merge Statement for SCD Type 2.

SQLeasy
3

Write a SQL query to find distinct IDs from a table where the count is more than 1 and greater than 200.

SQLeasy
4

Write a query for second-highest salary using LIMIT, OFFSET, or ROW_NUMBER()

SQLeasy
5

Write a query that identifies numbers appearing at least three times consecutively without interruption

SQLeasy
6

Write a query to find minimum age.

SQLeasy
7

Write a query to find the first number repeating consecutively three times in a sequence.

SQLeasy
8

Write a query to find the median salary of employees in a table.

SQLeasy

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

Get PDF Bundle — from $21Try Free Sample
Previous1...3031323334...36Next