SELECT [id]
,[gbzl]
,[mydate]
FROM [xxx]gbzl 是数值型mydate 是字符串 例其它数据有 2010-03-31 2000-01-12 1955-02-09 等1.我现在想查询出 每一年的gbzl数据相加查询出来!! 例2010 2000 1955 的gbzl的值,分别出来2.显示最近六年的记录!所有数据都是在库XXX里面!谢谢各位!!!
,[gbzl]
,[mydate]
FROM [xxx]gbzl 是数值型mydate 是字符串 例其它数据有 2010-03-31 2000-01-12 1955-02-09 等1.我现在想查询出 每一年的gbzl数据相加查询出来!! 例2010 2000 1955 的gbzl的值,分别出来2.显示最近六年的记录!所有数据都是在库XXX里面!谢谢各位!!!
这个没看懂
YEAR(mydate) AS 年份,
SUM(gbzl) AS gbzl
FROM [xxx]
WHERE year(mydate)<=year(getdate())
GROUP BY YEAR(mydate)
ORDER BY YEAR(mydate) desc
select top 6 year(mydate) as mydate ,sum([gbzl]) as gbzl
from [xxx]
group by year(mydate)
order by year(mydate)
--1.我现在想查询出 每一年的gbzl数据相加查询出来!! 例2010 2000 1955 的gbzl的值,分别出来
select mydate=left(mydate,4),sum(gbzl) from 表名 group by left(mydate,4)--2.显示最近六年的记录!
select * from 表名 where datediff(yy,mydate,getdate())<=6
1、select year(mydate) as 年份,sum(gbzl) from 表名 group by year(mydate)2、select top 6 * from 表名 group by year(mydate) order by year(mydate)desc