Commit6f21154

authored

Improved task 180

1 parent321420b commit6f21154Copy full SHA for 6f21154

File tree

-5

lines changed

-5

lines changed

Lines changed: 6 additions & 5 deletions

Original file line number	Diff line number	Diff line change
`@@ -1,6 +1,7 @@`
`1`	`1`	`# Write your MySQL query statement below`
`2`		`-# #Medium #Database #2022_06_26_Time_550_ms_(48.44%)_Space_0B_(100.00%)`
`3`		`-select distinct numas ConsecutiveNumsfrom`
`4`		`-(select num, lag(num,1) over(order by id)as l1, lag(num,2) over(order by id)as l2`
`5`		`-from Logs) con_thr`
`6`		`-where num= l1and num= l2`
	`2`	`+# #Medium #Database #2024_07_15_Time_469_ms_(89.19%)_Space_0B_(100.00%)`
	`3`	`+SELECT DISTINCTl1.numAS ConsecutiveNums`
	`4`	`+FROM Logs l1`
	`5`	`+JOIN Logs l2ONl1.id=l2.id-1`
	`6`	`+JOIN Logs l3ONl1.id=l3.id-2`
	`7`	`+WHEREl1.num=l2.numANDl2.num=l3.num;`

Comments

(0)