65 docs tagged with "MySQL"

LeetCode SQL Solution of Problem 1045. Customers Who Bought All Products. GROUP BY + HAVING Solution.

LeetCode SQL Solution of Problem 1070. Product Sales Analysis III. CTE + GROUP BY Solution.

LeetCode SQL Solution of Problem 1077. Project Employees III. Use RANK() Window Function to rank most experience employees in each project as 1

LeetCode SQL Solution of Problem 1098. Unpopular Books. GROUP BY + HAVING + LEFT JOIN Solution.

LeetCode SQL Solution of Problem 1107. New Users Daily Count. Solved Using Subquery and Count DISTINCT!

LeetCode SQL Solution of Problem 1112. Highest Grade For Each Student. RANK() Window Function Solution + CTE and Group By Solution.

LeetCode SQL Solution of Problem 1126. Active Businesses. AVG() Window Function Solution + Group By CTE Solution!

LeetCode SQL Solution of Problem 1132. Reported Posts II. Implemetation of LEFT JOIN and Count Solution!

LeetCode SQL Solution of Problem 1149. Article Views II. Implementation of Group By, Count DISTINCT, and CTE Solution!

LeetCode SQL Solution of Problem 1158. Market Analysis I. Simple and Efficient LEFT JOIN Solution!

[SOLVED with 3 Different Implementations] LeetCode SQL Solution of Problem [1264. Page Recommendations].

LeetCode SQL Solution of Problem [1445. Apples and Oranges]. 3 Different Approaches - Self Join, Pivot Data with CASE Statements, and Built-In PIVOT Operator.

LeetCode SQL Solution of Problem 175. Combine Two Tables. LEFT JOIN Solution.

LeetCode SQL Solution of Problem 176. Second Highest Salary. Rank() Window Function Solution + Limit Offset Solution.

LeetCode SQL Solution of Problem 177. Nth Highest Salary. Dense_Rank() Window Function Solution + Correlated Subquery Solution.

LeetCode SQL Solution of Problem 178. Rank Scores. Dense_Rank() Window Function Solution + Correlated Subquery Solution.

LeetCode SQL Solution of Problem [180. Consecutive Numbers]. Self Join Approach + Window Function Approach Lag() and Lead() Explained.

Solved with Self Join Technique - LeetCode SQL Solution of Problem 181. Employees Earning More Than Their Managers.

Solved with [Self Join] or [Group By]+[Having] Techniques - LeetCode SQL Solution of Problem 182. Duplicate Emails

LeetCode SQL Solution of Problem 183. Customers Who Never Order.

LeetCode SQL Solution of Problem 184. Department Highest Salary. Multiple Solutions Including RANK() Window Function.

Unlock the Solution to LeetCode Problem 185 - Department Top Three Salaries with These 4 SQL Solutions!

LeetCode SQL Solution of Problem 1919. Leetcodify Similar Friends.

LeetCode SQL Solution of Problem 196. Delete Duplicate Emails.

LeetCode SQL Solution of Problem [1965. Employees With Missing Information]. Combines the results of two queries using the UNION operator.

Two Solultions - Self Join Solution + Lag() Window Function Solution - Problem 197. Rising Temperature.

LeetCode SQL Solution of Problem 1972. First and Last Call On the Same Day. RANK() Window Function Implementation.

LeetCode SQL Solution of Problem [1978. Employees Whose Manager Left the Company]. Using SELF JOIN and LEFT JOIN Techniques.

LeetCode SQL Solution of Problem 2004. The Number of Seniors and Juniors to Join the Company. SUM() Window Function Solution.

Implementation utilizing Self Join, CTE, and Subquery Techniques. LeetCode SQL Solution of Problem [2084. Drop Type 1 Orders for Customers with Type 0 Orders].

LeetCode SQL Solution of Problem [2199. Finding the Topic of Each Post]. Solved using Recursive CTE, CHAR_LENGTH(), REPLACE(), SUBSTRING_INDEX(), and GROUP_CONCAT() functions.

LeetCode SQL Solution of Problem 262. Trips and Users. Solved with CTE, Group By, and CASE WHEN Statement.

LeetCode SQL Solution of Problem #511. Game Play Analysis I. Group By + Min() Solution.

[Solved!!!] First_Value() Window Function Implementation + Group By with Common Table Expression Implementation. LeetCode SQL Solution of Problem 512. Game Play Analysis II.

LeetCode SQL Solution of Problem 534. Game Play Analysis III. Correlated Subquery, Self Join, and SUM() Window Function Solutions.

LeetCode SQL Solution of Problem 550. Game Play Analysis IV. Common Table Expression Implementation.

LeetCode SQL Solution of Problem 569. Median Employee Salary.

LeetCode SQL Solution of Problem 570. Managers with at Least 5 Direct Report. CTE Implementation.

LeetCode SQL Solution of Problem 574. Winning Candidate. MySQL LIMIT and SQL Server TOP Implementation.

SQL Solution - The combination of the LEFT JOIN operation and the WHERE conditions ensures that the query retrieves employee names and their corresponding bonus amounts if the bonus is less than 1000 or if no bonus record exists for the employee.

LeetCode SQL Solution of Problem 578. Get Highest Answer Rate Question. Simple CTE Solution!

LeetCode SQL Solution of Problem 580. Count Student Number in Departments. Simple LEFT JOIN Solution.

LeetCode SQL Solution of Problem [584. Find Customer Referee].

LeetCode SQL Solution of Problem 585. Investments in 2016. Subquery and CTE with LEFT JOIN Solutions

SQL Solution - Group the orders based on customer numbers, count the number of orders for each customer, order the groups in descending order by the order count, and then limit the result to only one row.

LeetCode SQL Solution of Problem 601. Human Traffic of Stadium. Row_Number() Window Function Solution + Cross Join Solution.

LeetCode SQL Solution of Problem 602. Friend Requests II: Who Has the Most Friends. Subquery + UNION ALL Solution.

LeetCode SQL Solution of Problem [603. Consecutive Available Seats].

LeetCode SQL Solution of Problem 608. Tree Node. Self Join + Union Solution.

LeetCode SQL Solution of Problem 612. Shortest Distance in a Plane. Solution Using MIN(), SQRT(), POWER(), and CAST() Functions.

LeetCode SQL Solution of Problem 614. Second Degree Follower. Simple INNER SELF JOIN Solution.

LeetCode SQL Solution of Problem 626. Exchange Seats. SELF LEFT JOIN Implementation.

Need to clean up duplicate rows existing in existing tables? Use Group By, Self Join, or Window Function techniques to find and remove duplicate rows.

Gap Analysis - Using Self Join or Window Function techniques to find all gaps in a sequence of numbers.

MySQL Numbers Generator like generate_series in PostgreSQL! Using Recursive CTE or Cross Join SQL techniques to generate a virtual numbers table for any range of number. Print 1 to 100. Print 1 to 1001.

SQL techniques to group data by 5, 10, 15, 20, or 30 minute intervals. Round datetime up, round down, or round to nearest X minute interval.

Left Join is useful for finding missing records or for comparing data between two tables.

Right Join is useful for finding missing records or for comparing data between two tables.

MySQL INNER JOIN Syntax and Practical Examples

Island Analysis - Using Self Join or Window Function techniques to find all islands in a sequence of numbers.

Master the concept of inner join with the usage of range-based conditions. Demonstrate how to use inner joins effectively for specific data ranges with examples.

Simple examples demonstrating how RANK, DENSE_RANK, and ROW_NUMBER window functions handle ties differently

3 MySQL Solutions to Select Latest Record for Each Group

Select Top N Rows Per Group In MySQL Using Modern SQL Window Functions Rank(), Dense_Rank(), and Row_Number().

Never encounter Division By Zero Error again with 3 MySQL techniques. Solution 1 - NULLIF Function. Solution 2 - CASE Statement. Solution 3 - WHERE Clause.