SQLize Online / PHPize Online  /  SQLtest Online

A A A
Share      Blog   Popular
Copy Format Clear
CREATE TABLE tbl ( id serial, created_at date ); insert into tbl (created_at) values (NOW()), -- (NOW()),(NOW()),(NOW()),(NOW()),(NOW()), (NOW() - INTERVAL '1 day'), (NOW() - INTERVAL '2 day'), (NOW() - INTERVAL '3 day'), (NOW() - INTERVAL '4 day'), (NOW() - INTERVAL '5 day'), (NOW() - INTERVAL '6 day'), (NOW() - INTERVAL '7 day'), (NOW() - INTERVAL '8 day'), (NOW() - INTERVAL '9 day'), (NOW() - INTERVAL '10 day') ; with d as ( select *, row_number() over (order by created_at desc) rn, created_at >= (NOW() - INTERVAL '7 day') last_week from tbl order by created_at desc ) select * from d where last_week or rn < 11 ;
Stuck with a problem? Got Error? Ask ChatGPT!
Copy Clear