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); insert into test_w values (0, NULL, 1); insert into test_w values (0, 'N', 1); insert into test_w values (0, 'Нет', 1); insert into test_w values (0, 'Y', 1); insert into test_w values (0, 'Да', 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 -- DECODE(empl, -- NULL, 'N', -- 'Нет', 'Y', -- 'Да') AS prepaid_ind -- FROM test_w select 60 * 5 as first from test_w