查询语句
- SQL code
select 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
上面的语句怎么改，求大虾指点！！！！！！！！！！！
------解决方案--------------------
- SQL code
order by stateID desc，stepID
------解决方案--------------------
- SQL code
select stateID,stepID from pro1 where code=217 group by stateid,stepID order by stateid desc,stepID desc
------解决方案--------------------
------解决方案--------------------
- SQL code
select stateID,stepID from pro1 where code=217 group by stateid,stepID order by stateid desc,stepID