菜鸟问个查询结果排序的问题！请大家帮忙！

[hzgniit]

假设一个表有A,B两字段 A字段的内容表示年份 B字段的内容表示月份
查询出A和B 查询的结果怎么按年月排序？
请大家教教我！

[gahade]

select * from 表
order by a,b

[JL99000]

if object_id('tb') is not null
drop table tb
go
create table tb(A int, B int)
insert into tb
select 2007,1 union all
select 2007,10 union all
select 2007,2 union all
select 2007,4 union all
select 2007,3 union all
select 2007,5 union all
select 2008,2 union all
select 2007,1
select A,B from tb
order by A,B

[gahade]

字符型月份的话
select * from 表
order by a+right('0'+b,2)

[hzgniit]

忘说了，是按年月降序排列
请大家重新修改一下！
谢谢大家！

[areswang]

------------加个DESC
if object_id('tb') is not null
drop table tb
go
create table tb(A int, B int)
insert into tb
select 2007,1 union all
select 2007,10 union all
select 2007,2 union all
select 2007,4 union all
select 2007,3 union all
select 2007,5 union all
select 2008,2 union all
select 2007,1
select A,B from tb
order by A,B DESC

[gahade]

在后面加desc即可

[areswang]

order by A desc,B desc