SQLize Online / PHPize Online

A A A
Share   Donate   Blog   Popular
Copy Format Clear
create table users ( id int not null primary key, group_id int not null, invited_by_user_id int not null, name varchar(50) not null, posts_qty int not null ); insert into users (id, group_id, invited_by_user_id, name, posts_qty) values (1, 1, 0, 'Пользователь 1', 0), (2, 1, 1, 'Пользователь 2', 2), (3, 1, 2, 'Пользователь 3', 5), (4, 2, 3, 'Пользователь 4', 7), (5, 2, 4, 'Пользователь 5', 1); select * from users order by posts_qty desc limit 1;
Stuck with a problem? Need help? Ask professionals on our Telegram channel!
Join the channel
Your quersion is posted.
Join our Telegram channel and get answers.
Send
Copy