SQL Frequently Asked Interview Questions: Delete Duplicates Without Using Group By/Window Functions.

SQL Frequently Asked Interview Questions: Count(1) vs Count(*) vs Count(Column)

SQL Frequently Asked Interview Questions: Find Top 2 Highest Grossing Products from Each Category.

SQL Frequently Asked Interview Questions: Find nth Highest Salary.

#SQL Leetcode SQL 50 #50: Find Users With Valid E-Mails.

#SQL Leetcode SQL 50 #49: List Products Ordered in a Period.

#SQL Leetcode SQL 50 #48: Group Sold Products by the Date.

#SQL Leetcode SQL 50 #47: Find Second Highest Salary

#SQL Leetcode SQL 50 #46: Delete Duplicate Emails

#SQL Leetcode SQL 50 #45: Patients With a Condition.

#SQL Leetcode SQL 50 #44: Fix Names in a Table

#SQL Leetcode SQL 50 #43: Solving a Hard Leetcode Problem | Department Top 3 Salaries

#SQL Leetcode SQL 50 #42: Investments in 2016

#SQL Leetcode SQL 50 #41: Friend Requests II

#SQL Leetcode SQL 50 #40: Restaurant Growth | Using Window Functions.

#SQL Leetcode SQL 50 #39: Find Top User + Top Movie

#SQL Leetcode SQL 50 #38: Exchange Seats of Every Two Consecutive Students.

#SQL Leetcode SQL 50 #37: Employees Whose Manager Left the Company.

#SQL Leetcode SQL 50 #36: Find Salary Categories.

#SQL Leetcode SQL 50 #35: 1204. Last Person to Fit in the Bus

#SQL Leetcode SQL 50 #34: 1164: Product Price at a Given Date.

Dynamic SQL Explained Using Simple Examples!!

SQL Like Statement Explained Using Simple Examples!

SQL Working With Dates!

SQL Top 5 String Manipulation Functions!

SQL Cross Apply and Outer Apply Explained Using Simple Example.

SQL User Defined Functions aka UDFs.

SQL Foreign Key and Referential Integrity Explained Using Simple Example!

SQL Primary Key Explained Using Simple Examples.

SQL PIVOT Explained: Convert Rows to Columns Easily!

SQL How to Delete Duplicates Using Common Table Expression (CTE)

How to Download and Install Adventureworks Sample Database | Step-by-Step (2025 Update)

SQL Exists Operator Explained Using Simple Examples!

SQL Two Ways to Delete From a Table Using Another Table.

SQL Delete vs Truncate vs Drop Explained Using Simple Example

SQL Understanding the Merge Statement with Simple Examples.

SQL How to Handle NULL values?

SQL How to Find and Delete Duplicates Using ROW_NUMBER and CTE.

SQL Window Functions Explained Part 3| SUM OVER PARTITION BY ORDER BY

SQL Window Functions Explained Part 2| LEAD, LAG, OVER, ORDER BY, PATITION BY

SQL Window Functions Explained Part 1| ROW_NUMBER, RANK, DENSE_RANK, OVER, PARTITION BY, ORDER BY

How to Use Output Parameter in Stored Procedure?

SQL Stored Procedures Explained in Under 7 Minutes! #sql

SQL How to Delete Duplicates Using Group By?

SQL How to Create Summary Report and Calculate Totals Using Rollup?

SQL Recursive CTE Explained Using a Simple Example.

SQL Common Table Expression AKA CTE Explained Easily.

SQL How to Find Duplicate Records | Whole Row vs Partial Column Duplicates

SQL WHERE vs Having Clause Difference Explained Using Simple Examples.

SQL Group By Explained in Under 7 Minutes!

#SQL Leetcode SQL 50 #33: 180: Consecutive Numbers

SQL Correlated Subqueries Explained Using a Real-World Example!

SQL Subqueries Explained in 8 Minutes!

#SQL Leetcode SQL 50 #32. 610: Triangle Judgement

SQL Cross Joins Explained Using a Real-World Example!

#SQL Leetcode SQL 50 #31. 1789. Primary Department for Each Employee.

All SQL Joins Explained in 10 Minutes: Inner, Left, Right, Full, Cross, and Self Joins. #sql

#SQL Leetcode SQL 50 #30. 1731. The Number of Employees Which Report to Each Employee.

#SQL Leetcode SQL 50 #29. Customers Who Bought All Products

#SQL Leetcode SQL 50 #28: Biggest Single Number