如何将数据库表中的数据分组显示,如:
1 abc 2009
2 cde 2008
3 dfd 2008
4 dfa 2009
5 jkl 2007
6 jaa 2009
分组结果:
1 abc 2009
4 dfa 2009
6 jaa 2009
2 cde 2008
3 dfd 2008
5 jkl 2007
1 abc 2009
2 cde 2008
3 dfd 2008
4 dfa 2009
5 jkl 2007
6 jaa 2009
分组结果:
1 abc 2009
4 dfa 2009
6 jaa 2009
2 cde 2008
3 dfd 2008
5 jkl 2007
select * from tablename order by col3name
select * from 表 order by 第三列,第二列
select * from 表 order by 第三列,第二列
select * from 表 order by 第三列,第二列
查看 order by 用法升序ASC 降序DESC order by 字段 desc
--> 测试数据:
declare @t table([ID] int,[username] varchar(4),[dt] varchar(4))
insert @t
select'1', 'abc','2009' union all
select'2', 'cde','2008' union all
select'3', 'dfd','2008' union all
select'4', 'dfa','2009' union all
select'5', 'jkl','2007' union all
select'6', 'jaa','2009'
select * from @t
order by dt desc,username asc--结果
--------------------------------
ID username dt
1 abc 2009
4 dfa 2009
6 jaa 2009
2 cde 2008
3 dfd 2008
5 jkl 2007
SELECT * FROM tbl ORDER BY dt GROUP BY dt
先排序,接着分组。。