Hi! Could we please enable some services and cookies to improve your experience and our website?

SQLize Online / PHPize Online  /  SQLtest Online

A A A
Login    Share code      Blog   FAQ

Online Sandbox for SQL and PHP: Write, Run, Test, and Share SQL Queries and PHP Code

Copy Format Clear
create table T ( id_user int, year int ); -- insert into T values (1, 2022), (1, 2023), (2, 2023); insert into T values (1, 2022); insert into T values (1, 2023); insert into T values (2, 2023); select distinct t.id_user from T as t where t.year = 2023 and not exists (select id_user from T tt where year = 2022 and tt.id_user = t.id_user); select distinct t.id_user from T as t left join T tt on tt.year = 2022 and tt.id_user = t.id_user where t.year = 2023 and tt.id_user is null; select distinct t.id_user from T as t where t.year = 2023 except select distinct t.id_user from T as t where t.year = 2022 ;

Stuck with a problem? Got Error? Ask AI support!

Copy Clear