SQL - Questions for some job interviews

As you are aware, the majority of competent interviewers will be more interested in your approach and problem-solving skills than in meticulously examining your syntax. 

Instead of obsessing over understanding every scenario that may occur, concentrate more on the resources in your toolkit. 

In most recent interview, we examined a schema and answered a few queries about joins, filtering, aggregations (including running totals), CTEs, and rank/windows.

The most common things, you should be needed in the SQL interview:

• Simple things like Select Distinct, Count, Count Distinct, Min/Max, Sum.
• Windows functions like Lag, Over, Partition by
• Joins, using the filter clause in join to filter to one result instead of using where.
• Group by, Order By

1. Can you explain the difference between where and having?

Answer - When it comes to the sequence in which executable operations are performed, "WHERE" is used to filter out things from the table, while "HAVING" is used in conjunction with aggregate functions like "SUM" or "AVG" to filter out certain aggregated items.

Example - Fruits Data Table

OrderDate	Fruit	Price
11 Feb. 2024	Apple	$10.00
12 Feb. 2024	Banana	$5.00
13 Feb. 2024	Banana	$7.50
14 Feb. 2024	Mango	$12.00

 SQL Query -

"SELECT Fruit, Sum(Price) as Total 
FROM Fruits
WHERE Fruit = 'Banana' 
GROUP BY Fruit 
HAVING  Sum(Price) > 10.00;"

 2. Can you explain 𝗛𝗼𝘄 does 𝗦𝗤𝗟 statement execute?

Answer -The SQL execution order is the sequence in which the different clauses of a SQL query are executed. This order is important because it determines how the data is filtered, grouped, and ordered.

SQL - SQL Execution Order | 𝗛𝗼𝘄 𝗦𝗤𝗟 𝗤𝘂𝗲𝗿𝗶𝗲𝘀 𝗔𝗿𝗲 𝗘𝘅𝗲𝗰𝘂𝘁𝗲𝗱

3. How to remove duplicate records in SQL?

Answer - Duplicates in a dataset can skew analysis results. You can remove duplicates using the DISTINCT keyword or by using the GROUP BY clause.

How to remove duplicates records in SQL

3. How to find out employees and their manager in SQL query?

Answer - To achieve this in SQL, we are using self join technique to combine rows from two or more tables based on a related column between them.

Employee and their manager sql query example

To learn more, please follow us - 🔊 http://www.sql-datatools.com To Learn more, please visit our YouTube channel at — 🔊 http://www.youtube.com/c/Sql-datatools To Learn more, please visit our Instagram account at - 🔊 https://www.instagram.com/asp.mukesh/ To Learn more, please visit our twitter account at -

🔊 https://twitter.com/macxima