목록윈도우함수 (1)

HAZEL

[SQL : INNER JOIN , WINDOW FUNCTION ] LeetCode: 180. Consecutive Numbers

180. Consecutive Numbers >> 문제 +-------------+---------+ | Column Name | Type | +-------------+---------+ | id | int | | num | varchar | +-------------+---------+ id is the primary key for this table. Write an SQL query to find all numbers that appear at least three times consecutively. Return the result table in any order. The query result format is in the following example: Logs table: +----+-..
DATA ANALYSIS/SQL 2021. 3. 15. 19:27
이전 Prev 1 Next 다음