select year(日期字段),count(*) 数量 from 表 group by year(日期字段)??
select convert(char(4),year(日期字段)) from table group by convert(char(4),year(日期字段))
select Distinct convert(char(4),year(日期字段)) from table
select count(*) from (select left(日期字段,4)from 表 group by 日期字段)aa
select year(日期字段) as [year] from 表 group by year(日期字段) order by [year]
use pubs select sum(qty) as sum,convert(varchar(4),ord_date,120) as year from sales group by (convert(varchar(4),ord_date,120))
use pubs select sum(qty) as sum,convert(varchar(4),ord_date,120) as year from sales group by (convert(varchar(4),ord_date,120)) order by (convert(varchar(4),ord_date,120))
use pubs select sum(qty) as sum, DATEPART(yy,ord_date) as year from sales group by DATEPART(yy,ord_date) order by DATEPART(yy,ord_date)
select distinct convert(char(4),year(日期字段)) from *.db group by convert(char(4),year(日期字段))
select Distinct convert(char(4),year(日期字段)) ,count(convert(char(4),year(日期字段))) from table group by convert(char(4),year(日期字段)) 这回对了,我以前贴的错了
select sum(qty) as sum,convert(varchar(4),ord_date,120) as year from sales
group by (convert(varchar(4),ord_date,120))
select sum(qty) as sum,convert(varchar(4),ord_date,120) as year from sales
group by (convert(varchar(4),ord_date,120)) order by (convert(varchar(4),ord_date,120))
select sum(qty) as sum, DATEPART(yy,ord_date) as year from sales
group by DATEPART(yy,ord_date) order by DATEPART(yy,ord_date)
这回对了,我以前贴的错了