关于查询语句按两个字段排序问题，不知道可不可以，求大虾指点！！！！！

[Dotar]

查询语句

SQL codeselect stateID,stepID from pro1 where code=217 group by stateid,stepID order by stateid,stepID desc

查出来的结果是
stateID stepID：
1 2
1 1
1 0
2 1
2 0
我想要的结果是：
stateID stepID
2 1
2 0
1 2
1 1
1 0

上面的语句怎么改，求大虾指点！！！！！！！！！！！

[冰镇宝贝321]

2 1
2 0
1 2
1 1
1 0

搞什么 前2个是按第一个数字大小排序 后面三个 就按第二个数字大小排列

完全没规律啊

[冰镇宝贝321]

额 不好意思 看错了



可以得出结果的

[冰镇宝贝321]

select stateID,stepID from pro1 where code=217 group by stateid,stepID order by stepID,stateid desc
试试看

[Ny-6000]

order by stateid DESC ,stepID desc

[EnForGrass]

select stateID,stepID from pro1 where code=217 group by stateid,stepID order by stateid asc,stepID desc

[EnForGrass]

该是stateid 降序
select stateID,stepID from pro1 where code=217 group by stateid,stepID order by stateid desc,stepID desc

[bdmh]

stateid desc,stepID desc 两个字段都降序排列

[lisweden]

order by stateid ASC,stepID DESC

[Dotar]

[Quote=引用 8 楼 lisweden 的回复:]
order by stateid ASC,stepID DESC
[/Quote]

你这样错了
！！！

[Dotar]

[Quote=引用 6 楼 chinajiyong 的回复:]
该是stateid 降序
select stateID,stepID from pro1 where code=217 group by stateid,stepID order by stateid desc,stepID desc
[/Quote]


正解！！！！！！

[chen_ya_ping]

stateID stepID
2 1
2 0
1 2
1 1
1 0

order by stateid desc ,stepID DESC