昨天参加了广联达的笔试题,简单复盘SQL相关的题目。
1.其实这道SQL并不是很难,奈何我都没做对,所以今日复盘一下。
题目:表post_table,有3个字段,uid : 会员id, post_time:发帖时间,content:发帖内容
create table post_table(uid int ,
post_time datetime,
content char(6));
insert into post_table values (1,‘2019-03-01 0:00:00’,‘a’);
insert into post_table values (2,‘2019-03-01 0:00:01’,‘b’);
insert into post_table values (3,‘2019-03-01 0:00:02’,‘c’);
insert into post_table values (3,‘2019-03-01 0:00:03’,‘d’);
insert into post_table values (3,‘2019-03-01 0:00:04’,‘e’);
insert into post_table values (2,‘2019-03-01 0:00:05’,‘f’);
insert into post_table values (2,‘2019-03-01 0:00:06’,‘g’);
insert into post_table values (1,‘2019-03-01 0:00:07’,‘h’);
insert into post_table values (4,‘2019-03-01 0:00:08’,‘i’);
insert into po