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的人执行上述语句
解决方案 »
- =====请问一下大家,怎样用SQL实现下面的效果呀?=====
- oracle sql与标准的sql语句的区别?
- select 和 update
- 用Oracle9i卸载升过级Oracle9i
- oracle的备份
- C1F18748797132CFA4F9E7A65464424B问题
- c/s结构的程序如何在不安装ORALE客户端的情况下运行??
- update 的问题
- oracle操作出现问题
- 【求教】教集深数据系统导入报表报错不能使用?
- 有谁知道:如何以系统时间的日(Day)为1时,触发修改一个系统变量的触发器内容?
- Oracle9.2里面是不是有什么占用了8080端口,致使我的Tomcat和Resin都不好用了???
(select sum(score) as total from diaryaudit group by employeeid order by sum(score) desc ) T;
倒霉啊,倒霉,实际运行环境是oracle7的,更惨.