SQLize Online / PHPize Online  /  SQLtest Online

A A A
Share      Blog   Popular
Copy Format Clear
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

Stuck with a problem? Got Error? Ask ChatGPT!

Copy Clear