• Skip to primary navigation
  • Skip to content
  • Skip to footer
Thomas Ngo Thomas Ngo
  • Home
  • Journal
  • Tags
  • About

    Thomas Ngo

    Software Engineer

    • Stanton, California
    • Email
    • GitHub
    • Resume

    SQL problem - Consecutive Numbers

    February 25, 2024 less than 1 minute read

    Page Navigation

    • Problem
    • Query

    Problem

    problem-180

    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
    

    Tags: SQL

    Updated: February 25, 2024

    Share on

    Twitter Facebook LinkedIn
    Previous Next

    You may also enjoy

    Problem of The Day: Best Time to Buy and Sell Stock with Transaction Fee

    February 1, 2026 1 minute read

    Problem Statement

    Problem of The Day: Longest Common Subsequence

    January 31, 2026 2 minute read

    Problem Statement

    Problem of The Day: Unique Paths

    January 29, 2026 1 minute read

    Problem Statement

    Problem of The Day: House Robber

    January 27, 2026 2 minute read

    Problem Statement

    • Follow:
    • GitHub
    • LinkedIn
    © 2026 Thomas Ngo.