SQLize Online / PHPize Online  /  SQLtest Online

A A A
Share      Blog   Popular
Copy Format Clear
CREATE TABLE test( dt date, total numeric(38, 2) ) ; insert into test(dt, total) VALUES (to_date('26.02.2013', 'dd.mm.yyyy'), 312.00); insert into test(dt, total) VALUES (to_date('05.03.2013', 'dd.mm.yyyy'), 833.00); insert into test(dt, total) VALUES (to_date('12.03.2013', 'dd.mm.yyyy'), 225.00); insert into test(dt, total) VALUES (to_date('19.03.2013', 'dd.mm.yyyy'), 453.00); insert into test(dt, total) VALUES (to_date('26.03.2013', 'dd.mm.yyyy'), 774.00); insert into test(dt, total) VALUES (to_date('02.04.2013', 'dd.mm.yyyy'), 719.00); insert into test(dt, total) VALUES (to_date('09.04.2013', 'dd.mm.yyyy'), 136.00); insert into test(dt, total) VALUES (to_date('16.04.2013', 'dd.mm.yyyy'), 133.00); insert into test(dt, total) VALUES (to_date('23.04.2013', 'dd.mm.yyyy'), 157.00); insert into test(dt, total) VALUES (to_date('30.04.2013', 'dd.mm.yyyy'), 850.00); insert into test(dt, total) VALUES (to_date('07.05.2013', 'dd.mm.yyyy'), 940.00); insert into test(dt, total) VALUES (to_date('14.05.2013', 'dd.mm.yyyy'), 933.00); insert into test(dt, total) VALUES (to_date('21.05.2013', 'dd.mm.yyyy'), 422.00); insert into test(dt, total) VALUES (to_date('28.05.2013', 'dd.mm.yyyy'), 952.00); insert into test(dt, total) VALUES (to_date('04.06.2013', 'dd.mm.yyyy'), 136.00); insert into test(dt, total) VALUES (to_date('11.06.2013', 'dd.mm.yyyy'), 701.00) ; select* from test;
Stuck with a problem? Got Error? Ask ChatGPT!
Copy Clear