SQL problem - Consecutive Numbers

February 25, 2024 less than 1 minute read

1 min read 104 words

Problem

Query

SELECT DISTINCT
    l1.num AS ConsecutiveNums
FROM
    Logs AS l1,
    Logs AS l2,
    Logs AS l3
WHERE 
    l1.num = l2.num AND l1.num = l3.num AND l1.id = l2.id - 1 AND l1.id = l3.id - 2

Share on

X Facebook LinkedIn Bluesky

Remove N-th Node From End of List in C#

2 minute read

Learn how to remove the n-th node from the end of a singly-linked list using the two-pointer approach in C#.

Mastering Kusto Query Language (KQL) in Azure Application Insights

2 minute read

A professional guide to using Kusto Query Language (KQL) to explore, analyze, and visualize your Application Insights data.

LeetCode: Reorder List in C#

4 minute read

Learn how to reorder a singly-linked list in-place using the slow/fast pointer technique, list reversal, and alternate merging in C#.

Median of Two Sorted Arrays in C#

5 minute read

Learn how to find the median of two sorted arrays using both an intuitive merging approach and the optimal O(log(N+M)) binary search approach in C#.

Thomas Ngo