SQLize Online / PHPize Online  /  SQLtest Online

A A A
Share      Blog   Popular
Copy Format Clear
create table comments ( id serial, post_id int, comment text, created_at timestamp default now() ); insert into comments (post_id, comment) values (1, 'post 1 kfdjbfk;gb'), (1, 'post 1 kfdjbfk;gb'), (2, 'post 2 aaaaaaaaa'), (1, 'post 1 kfdjbfk;gb'), (2, 'post 2 bbbbbbbbbbb'), (1, 'post 1 kfdjbfk;gb'); with last_comments as ( select *, row_number() over (partition by post_id order by created_at desc) rn from comments where post_id in (1,2,3) ) select id, post_id, comment from last_comments where rn < 4;
Stuck with a problem? Got Error? Ask ChatGPT!
Copy Clear