SQLize Online / PHPize Online  /  SQLtest Online

A A A
Share      Blog   Popular
Copy Format Clear
create table tbl ( id int, timestamp time, price int); insert into tbl values (1, '12:13', 100), (2, '12:14', 120), (3, '12:15', 100), (4, '12:16', 100), (5, '12:17', 110); select * from tbl; delete tbl.* from tbl join ( select id, lag(price) over (order by id) price from tbl ) l on tbl.id = l.id and tbl.price = l.price; select * from tbl;
Stuck with a problem? Got Error? Ask ChatGPT!
Copy Clear