SQLize Online / PHPize Online  /  SQLtest Online

-- create table test_w (cnt int, empl varchar(50), id int); -- ------------------------------------------------------ -- insert into test_w values (20, 'Слесарь', 2); -- insert into test_w values (30, 'Монтажник', 2); -- insert into test_w values (20, 'Монтажник', 3); -- insert into test_w values (50, 'Уборщик', 3); -- insert into test_w values (20, 'Директор', 1); -- ------------------------------------------------------ -- select t1.*, sum(t2.cnt) from test_w t1 -- left join test_w t2 -- on t1.id <= t2.id -- group by t1.cnt, t1.empl, t1.id select to_date('2025-09-01', 'yyyy-mm-dd') + (level - 1) as dt from dual connect by (to_date('2025-09-01', 'yyyy-mm-dd') + (level - 1)) < add_months(to_date('2025-09-01', 'yyyy-mm-dd'), 12)