SQL Scenario based Interview Questions (LeetCode - Consecutive Numbers)
SQL script to create table:
create table logs(id int not null primary key,num varchar(20));
insert into logs values(1,'1'),(2,'1'),(3,'1'),(4,'2'),(5,'1'),(6,'2'),(7,'2');
SQL script to create table:
create table logs(id int not null primary key,num varchar(20));
insert into logs values(1,'1'),(2,'1'),(3,'1'),(4,'2'),(5,'1'),(6,'2'),(7,'2');