SQLize Online / PHPize Online  /  SQLtest Online

create table test_w (cnt float, empl varchar(50), id int); ------------------------------------------------------ insert into test_w values (20.4, ' Слесарь', 2); insert into test_w values (30.6, 'Монтажник ', 2); insert into test_w values (20.1, ' Монтажник', 3); insert into test_w values (50.9, 'Уборщик', 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 empl FROM test_w WHERE empl <> 'Директор' -- ceil(cnt), -- floor(cnt) -- DECODE(empl, -- NULL, 'N', -- 'Нет', 'Y', -- 'Да') AS prepaid_ind -- strpos(empl, 'а') -- SELECT foo FROM regexp_split_to_table('the quick brown fox jumps over the lazy dog', '\d*') AS foo;