select column1 from tablename group by column1 order by column2
要转一个弯才行吧? --测试: create table tb_1(aa varchar2(10),bb varchar2(10),cc number); insert into tb_1 values('1','a',20); insert into tb_1 values('1','d',20); insert into tb_1 values('2','b',11); insert into tb_1 values('2','a',12); insert into tb_1 values('2','d',13);select * from ( select aa,sum(cc) as cc from tb_1 group by aa ) order by cc;/*AA CC ---------- ---------- 2 36 1 40已选择2行。*/
SQL> INSERT INTO TESTA VALUES(1,'OK');1 row created.SQL> INSERT INTO TESTA VALUES(2,'OK2');1 row created.SQL> INSERT INTO TESTA VALUES(2,'P');1 row created.SQL> INSERT INTO TESTA VALUES(3,'A');1 row created.SQL> COMMIT;Commit complete.SQL> SELECT * FROM TESTA; ID NAME --------- -------------------------------------------------- 1 OK 2 OK2 2 P 3 ASQL> SELECT A.ID,A.NAME FROM TESTA A GROUP BY A.ID,A.NAME ORDER BY A.NAME; ID NAME --------- -------------------------------------------------- 3 A 1 OK 2 OK2 2 P
--测试:
create table tb_1(aa varchar2(10),bb varchar2(10),cc number);
insert into tb_1 values('1','a',20);
insert into tb_1 values('1','d',20);
insert into tb_1 values('2','b',11);
insert into tb_1 values('2','a',12);
insert into tb_1 values('2','d',13);select * from (
select aa,sum(cc) as cc from tb_1 group by aa )
order by cc;/*AA CC
---------- ----------
2 36
1 40已选择2行。*/
bzszp(www.bzszp.533.net) 兄的回答解决了我的问题,谢谢
--------- --------------------------------------------------
1 OK
2 OK2
2 P
3 ASQL> SELECT A.ID,A.NAME FROM TESTA A GROUP BY A.ID,A.NAME ORDER BY A.NAME; ID NAME
--------- --------------------------------------------------
3 A
1 OK
2 OK2
2 P