可以啊!
请看:
SQL> select * from test; ID COUNT_1 TYPE_1
---------- ---------- ----------
1 2 1
1 3 2
2 5 1
2 8 5SQL> select count_1 from test order by type_1 desc; COUNT_1
----------
8
3
2
5SQL> select id,count_1 from test order by type_1 desc; ID COUNT_1
---------- ----------
2 8
1 3
1 2
2 5
请看:
SQL> select * from test; ID COUNT_1 TYPE_1
---------- ---------- ----------
1 2 1
1 3 2
2 5 1
2 8 5SQL> select count_1 from test order by type_1 desc; COUNT_1
----------
8
3
2
5SQL> select id,count_1 from test order by type_1 desc; ID COUNT_1
---------- ----------
2 8
1 3
1 2
2 5
有人知道这个特例吗?