34,838
社区成员
发帖
与我相关
我的任务
分享菜鸟问个查询结果排序的问题！请大家帮忙！
假设一个表有A,B两字段 A字段的内容表示年份 B字段的内容表示月份
查询出A和B 查询的结果怎么按年月排序？
请大家教教我！
查询出A和B 查询的结果怎么按年月排序？
请大家教教我！
...全文
请发表友善的回复…
发表回复
areswang 2008-02-27
- 打赏
- 举报
order by A desc,B desc
gahade 2008-02-27
- 打赏
- 举报
在后面加desc即可
areswang 2008-02-27
- 打赏
- 举报
------------加个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
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
hzgniit 2008-02-27
- 打赏
- 举报
忘说了，是按年月降序排列
请大家重新修改一下！
谢谢大家！
请大家重新修改一下！
谢谢大家！
gahade 2008-02-27
- 打赏
- 举报
字符型月份的话
select * from 表
order by a+right('0'+b,2)
select * from 表
order by a+right('0'+b,2)
JL99000 2008-02-27
- 打赏
- 举报
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
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 2008-02-27
- 打赏
- 举报
select * from 表
order by a,b
order by a,b
