MySQL面试题：查询每个日期的胜负次数_CDA答疑社区

热线电话：13121318867

登录

读童话的狼

2020-09-01 阅读量: 1108

MySQL面试题：查询每个日期的胜负次数

record表结构如下:

请用SQL实现以下结果

create table record(

time0 datetime,

shengfu varchar(10));

insert into record(time0,shengfu)

values('2015-01-12 00:00:00.000','胜'),

('2016-12-09 00:00:00.000','负'),

('2013-05-22 00:00:00.000','胜'),

('2015-01-12 00:00:00.000','胜'),

('2013-05-22 00:00:00.000','胜'),

('2016-01-12 00:00:00.000','负');

select * from record;

select time0,sum(shengfu='胜') 胜,sum(shengfu='负') 负 from record group by time0 order by time0;

42.9290

5

0

关注作者

收藏

评论(0)

发表评论

暂无数据

CDA考试动态

CDA报考指南

推荐帖子