create table login
(ldate date,cust_id varchar(20))
insert into login values('2024-01-01','C1'),
insert into login values('2024-01-01','C2'),
insert into login values('2024-01-01','C3'),
insert into login values('2024-01-01','C4'),
insert into login values('2024-01-02','C5'),
insert into login values('2024-01-02','C1'),
insert into login values('2024-01-03','C6'),
insert into login values('2024-01-03','C2'),
insert into login values('2024-01-03','C7'),
insert into login values('2024-01-04','C1'),
insert into login values('2024-01-04','C2'),
insert into login values('2024-01-04','C8'),
Негізгі бет SQL Interview Questions | How to identify the new Users and repeated users in SQL | SQL | SQL Server
Пікірлер