java面试题_SQL_取某年的各个月份的发邮件数
来源:互联网 发布:网络渗透技术难吗 编辑:程序博客网 时间:2024/06/13 22:51
1、算出07年每个月发送邮件的总数
准备数据:
user表
create table users(
id int primary key auto_increment,
name varchar(25)
);
insert into users(name) values ('sunhaojie1');
insert into users(name) values ('sunhaojie2');
insert into users(name) values ('sunhaojie3');
create table events(
id int primary key auto_increment,
create_date Date,
type int,
user_id int,
foreign key (user_id) references users (id)
);
type=1,发送邮件
type=2,接受邮件
insert into events(create_date,type,user_id) values('2007-01-12','1',1);
insert into events(create_date,type,user_id) values('2007-01-12','2',2);
insert into events(create_date,type,user_id) values('2007-01-12','1',3);
insert into events(create_date,type,user_id) values('2007-02-12','1',1);
insert into events(create_date,type,user_id) values('2007-02-12','1',1);
insert into events(create_date,type,user_id) values('2007-02-12','2',3);
insert into events(create_date,type,user_id) values('2007-03-12','1',1);
insert into events(create_date,type,user_id) values('2007-03-12','1',1);
insert into events(create_date,type,user_id) values('2007-03-12','1',2);
insert into events(create_date,type,user_id) values('2007-04-12','1',1);
insert into events(create_date,type,user_id) values('2007-04-12','2',1);
insert into events(create_date,type,user_id) values('2007-04-12','1',1);
insert into events(create_date,type,user_id) values('2007-05-12','1',3);
insert into events(create_date,type,user_id) values('2007-05-12','2',1);
insert into events(create_date,type,user_id) values('2007-05-12','1',1);
insert into events(create_date,type,user_id) values('2007-06-12','1',1);
insert into events(create_date,type,user_id) values('2007-06-12','3',3);
insert into events(create_date,type,user_id) values('2007-06-12','1',1);
insert into events(create_date,type,user_id) values('2007-07-12','1',1);
insert into events(create_date,type,user_id) values('2007-07-12','2',1);
insert into events(create_date,type,user_id) values('2007-07-12','1',2);
insert into events(create_date,type,user_id) values('2007-08-12','1',1);
insert into events(create_date,type,user_id) values('2007-08-12','2',2);
insert into events(create_date,type,user_id) values('2007-08-12','1',3);
insert into events(create_date,type,user_id) values('2007-09-12','1',1);
insert into events(create_date,type,user_id) values('2007-09-12','1',1);
insert into events(create_date,type,user_id) values('2007-09-12','2',1);
insert into events(create_date,type,user_id) values('2007-10-12','1',2);
insert into events(create_date,type,user_id) values('2007-10-12','1',1);
insert into events(create_date,type,user_id) values('2007-10-12','1',1);
insert into events(create_date,type,user_id) values('2007-11-12','1',1);
insert into events(create_date,type,user_id) values('2007-11-12','2',3);
insert into events(create_date,type,user_id) values('2007-11-12','1',1);
insert into events(create_date,type,user_id) values('2007-11-12','1',1);
insert into events(create_date,type,user_id) values('2007-12-12','1',1);
insert into events(create_date,type,user_id) values('2007-12-12','2',3);
insert into events(create_date,type,user_id) values('2007-12-12','2',1);
insert into events(create_date,type,user_id) values('2007-12-12','2',1);
insert into events(create_date,type,user_id) values('2007-10-12','1',1);
insert into events(create_date,type,user_id) values('2007-08-12','1',3);
查询语句:
select count(month), month from
(select type, date_format(create_date,'%c') month from events where type = 1) as te
group by te.month;
- java面试题_SQL_取某年的各个月份的发邮件数
- java面试题_SQL_取某年的各个月份的发邮件数
- 11月份的Java面试题新鲜出炉
- 发邮件的JAVA程序
- java发邮件的实现
- java发邮件的代码
- SQLite: 取某年份的数据
- CSDN11月份的Java面试题新鲜出炉(考试必备)
- Java各个类型的取值范围
- 【面试题】在一个含有n个元素的集合中随机取一个数
- java的面试题
- 简易的java发邮件客户端
- java实现发邮件的代码
- Java发邮件的几种方式:
- Java面试题-朋友的面试题
- 给定一个整数,如何取其各个位的数
- 取上个月月份的SQL
- 发邮件的写法
- backtrace
- Linux RedHat 9 QT4的编译、调试环境的搭建
- 在ASP.NET动态页中生成静态页面
- 一个自己写的用来搜索各种文件格式生成txt清单的java工具
- Struts+Hibernate+MySql中文乱码解决方案
- java面试题_SQL_取某年的各个月份的发邮件数
- 为何我的眼里泪光闪烁,因为我对安财爱的深沉 [法学院学哥]
- Silverlight 教程第二部分:使用布局管理
- 第一次写博
- protel99 se 使用 总结
- oracle有时不能登陆了
- 尚学堂视频
- 时间
- 我的数码单反相机,艰难的选择!