Question Bank
SQL & Databases interview questions
A SQL query must remain correct with duplicates, NULL values and unusual relationships between tables. Explain joins and grouping before considering execution cost. Test your reasoning with a small table containing edge cases.
Showing 12 of 72 questions
As I understand it, these two tables are linked by a key: id in the first table and employ in the second?
Practice in botTo return only what was requested, would we use another subquery?
Practice in botThe task is to write a SQL query that selects unusual days for all publishers. The output format is not important: you can select only the relevant days, or return all days with a 1 or 0 next to each. Do not worry about those details; focus on the main problem.
What would work better than LAG and LEAD?
What is the problem? What exactly would I break?
How would you solve this problem in plain SQL?
Can you describe your team and the challenges you work on in detail?
Prepare for your next interview with Vibe Interview.
Download Vibe Interview