Consecutive numbers sql

SELECT DISTINCT l1.Num AS ConsecutiveNums FROMLogs AS l1, Logs AS l2, Logs AS l3WHERE l1.Num = l2.Num AND l2.Num = l3.Num ANDl1.Id = l2.Id - 1 AND l2.Id = l3.Id - 1;

Source: nifannn.github.io

Similar codes

10 votes285 views2 answers
Rtrim sql
SQL
0 vote312 views1 answer
Netstat -tln mysql
SQL
1 vote313 views1 answer
Oracle see column type
SQL
28 votes314 views6 answers
Sql update
SQL
-1 vote278 views1 answer
Count occurrences sql
SQL
6 votes286 views2 answers
What is non relational database
SQL
0 vote278 views1 answer
Nosql vs sql
SQL
8 votes238 views8 answers
Second highest salary in mysql
SQL
10 votes297 views2 answers
SQL rounding numbers
SQL
0 vote265 views1 answer
How to change the field size of an existing column
SQL