This post covers an SQL scenario, and how to solve it with NON ANSI 92 aggregate functions. Refer to your database documentation for the additional aggregate functions. In this post …

LEAD(..) & LAG(..) are Window functions, which perform operations for each row of the partition or window. LEAD() and LAG() are used to accesses a value stored in a row …

This extends 50+ SQL scenarios based interview Q&As on Nth value with some variations to practice. Problem statement & considerations Find the 5th highest salary for each department. If the …

Let’s try solving a problem statement given below by creating sample data & then an SQL query on db-fiddle using MySQL v8 database. You can also look at a hierarchical …

In this post let’s look at an SQL scenario, and three different ways to solve this scenario. There could be more ways to solve an SQL scenario. Problem Statement Given …

In SQL often we need to merge records from a source table to a target table. The source table could be a staging table where the source system sent new …

Let’s look at a standard teams interview question to understand your SQL knowledge in using a non-equi join. Problem Statement 1 Given the below 5 teams

Here is another SQL scenario based interview question to determine a candidate’s ability to translate a business requirement into an SQL query. Problem Statement Given the below data of running …

Here is another SQL scenario based interview question to determine a candidate’s ability to translate a business requirement into an SQL query. These are scenarios where you want to find …

Let’s look at a very common problem statement of finding out the repeat customers, repeat visits, etc. The key to this problem is first determining the first visit or first …