8.17 确实没问题:
SQL> create table diaryaudit(employeeid number(2),score number(3));
SQL> insert into diaryaudit values(1,200);
SQL> insert into diaryaudit values(3,250);
insert into diaryaudit values(31,650);
SQL> commit;
SQL> select * from diaryaudit;EMPLOYEEID SCORE
---------- ----------
1 200
3 250
31 650SQL> select sum(score) as total from diaryaudit group by employeeid order by total; TOTAL
----------
200
250
650SQL> select rownum,T.total from
2 (select sum(score) as total from diaryaudit group by employeeid order by total desc ) T; ROWNUM TOTAL
---------- ----------
1 650
2 250
3 200让8.05的人执行上述语句
SQL> create table diaryaudit(employeeid number(2),score number(3));
SQL> insert into diaryaudit values(1,200);
SQL> insert into diaryaudit values(3,250);
insert into diaryaudit values(31,650);
SQL> commit;
SQL> select * from diaryaudit;EMPLOYEEID SCORE
---------- ----------
1 200
3 250
31 650SQL> select sum(score) as total from diaryaudit group by employeeid order by total; TOTAL
----------
200
250
650SQL> select rownum,T.total from
2 (select sum(score) as total from diaryaudit group by employeeid order by total desc ) T; ROWNUM TOTAL
---------- ----------
1 650
2 250
3 200让8.05的人执行上述语句
解决方案 »
- oracle安装错误
- Oracle表结构如何导入到Access中
- 入门真难!!!
- 设置oracle自动提交
- oracle 触发器的问题 请高手
- oracle过程中执行动态的Sql语句Sql_insert:='insert into '|| srctable || '('||fielda,filedb||')'|| ' values( '||a,b ||')',有具体说
- 表锁了,怎么处理
- 客户端问题
- 这个问题能够实现哇?
- 求助!!!导入表结构的问题
- 有谁知道:如何以系统时间的日(Day)为1时,触发修改一个系统变量的触发器内容?
- Oracle9.2里面是不是有什么占用了8080端口,致使我的Tomcat和Resin都不好用了???
(select sum(score) as total from diaryaudit group by employeeid order by sum(score) desc ) T;
倒霉啊,倒霉,实际运行环境是oracle7的,更惨.