需要用convert函数转换日期格式,并且需要用group by来实现分组。
1、创建测试表及插入数据:
create table test
(tdate datetime,
sal int);
insert into test values ('2015-09-23 12:22:22',100);
insert into test values ('2015-09-23 01:54:34',456);
insert into test values ('2015-09-24 14:32:35',45);
insert into test values ('2015-09-24 22:23:43',67);
insert into test values ('2015-09-25 19:43:22',234);
insert into test values ('2015-09-25 08:14:12',67);
insert into test values ('2015-09-26 04:53:34',45);
insert into test values ('2015-09-26 09:46:54',78);
2、执行sql语句:
select convert(varchar(10),tdate,120) tdate,sum(sal) sal from test group by convert(varchar(10),tdate,120);
3、执行结果:
很简单呀
你使用select语句
后面加上日期就行了
select * from 表名 order by 日期 desc
select distinct 日期 from table
SELECT
Convert ( VARCHAR(10), 日期, 120) AS 日期
COUNT(*) AS 记录数
FROM
表
GROUP BY
Convert ( VARCHAR(10), 日期, 120)
女子落魄鼓舞人心所以