SQLize Online / PHPize Online  /  SQLtest Online

A A A
Share      Blog   Popular
Copy Format Clear
CREATE TABLE users ( id int auto_increment primary key, name varchar(64) ); CREATE TABLE posts ( id int auto_increment primary key, user_id int, post text, index(user_id), foreign key (user_id) references users(id) ); insert into users (name) values ('User1'),('User2'),('User3'),('User4'); insert into posts (user_id, post) values (1, 'Post11'),(1, 'Post12'),(1, 'Post13'),(1, 'Post14'), (2, 'Post21'),(2, 'Post22'); select users.*, posts.post, row_number() over ( partition by user_id order by posts.id desc) post_num from users left join posts on users.id = posts.user_id where post_num < 4 order by users.id, post_num asc
Stuck with a problem? Got Error? Ask ChatGPT!
Copy Clear