有个日期字段,想用一条SQL能列出所有的年份并排序,比如有5条数据:
1. 2006-1-1
2. 2006-4-2
3. 2007-7-2
4. 2007-12-1
5. 2008-1-2想得到结果为:1. 2008
2. 2007
3. 2006
1. 2006-1-1
2. 2006-4-2
3. 2007-7-2
4. 2007-12-1
5. 2008-1-2想得到结果为:1. 2008
2. 2007
3. 2006
1. 2006-1-1
2. 2006-4-2
3. 2007-7-2
4. 2007-12-1
5. 2008-1-2 select distinct year(日期) from tb order by year(日期) desc
select datepart(yy,日期字段) from 表名 group by datepart(yy,日期字段) order by datepart(yy,日期字段) desc
或者:
select distinct datepart(yy,日期字段) from 表名 order by datepart(yy,日期字段) desc
结帖!散分。