7 docs tagged with "Self Join"

SQL Server: Calculate Running Total or Cumulative Sum with Self Join

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 [180. Consecutive Numbers]. Self Join Approach + Window Function Approach Lag() and Lead() Explained.

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

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.

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