JavaScript is required to use this application. Please enable JavaScript in your browser settings or disable any extensions that may be blocking scripts.
Questions tagged sql · medium
Write an SQL query to find the second-highest salary from an employee table.
Explain the differences between Data Warehouse, Data Lake, and Delta Lake
Can you explain the difference between OLTP and OLAP?
Describe a time when you had to optimize a slow SQL query. What steps did you take?
How do you handle NULL values in SQL? Mention functions like COALESCE and NULLIF.
What is the difference between WHERE and HAVING clauses in SQL?
Explain the concept of Broadcast Join in Spark. When should it be used?
What is the difference between SQL and NoSQL databases?
Get the complete 1,800+ question library with detailed, expert-level answers covering SQL, Spark, System Design, Python, Cloud, and Behavioral topics.