select * from (
select *, (select count(*) from table) from table
) as temp执行以上语句,报错:invalid use of an aggegate function!
有人可以解释一下吗?注:请不要使用 select *, count(*) from table group by 列。
select *, (select count(*) from table) from table
) as temp执行以上语句,报错:invalid use of an aggegate function!
有人可以解释一下吗?注:请不要使用 select *, count(*) from table group by 列。
解决方案 »
- 如何保证多进程取一个表数据不重复?
- 关于system/manager问题
- 初学Oracle,请高手指点下
- ORACLE下如何把某个表的内容输出成WORD格式?
- oracle连接问题?
- ORACLE服务?
- 怎样插入大于4000的字符串?第---3-----次发
- 郁闷!安装oracle后所有操作都只能在系统的本机帐户上进行,在域的帐号上什么都不能作!
- 我是oracle 9i 的Integrated Management Tools里中oracle directory manager无法连接,提示服务器未启动
- 商品信息子系统(帮忙了啊!急!)
- 哪位大虾能帮我解释一下这段方法,能具体说道各个名称的作用最好
- 哪位大虾帮我把sql的存储过程转换为oracle的存储过程,非常感谢
select code as 'a', [name] as 'b', (select count(*) from table) as 'c' from table
) as temptable 表有两个字段,code和name。执行以上语句,报错:invalid use of an aggegate function!
有人可以解释一下吗?
这个也报错,吗?
select code as 'a', [name] as 'b', (select count(*) from table) as 'c' from table
) as temptable 表有两个字段,code和name。执行以上语句,报错:invalid use of an aggegate function!
有人可以解释一下吗?
select * from
(
select t.*,select count(*)over(order by 1) cn from table t
) temp
--还没解决?select * from (
select a.*, (select count(*) from table) from table a
) temp
SQL> select * from (
2 select a.*, (select count(*) from emp) from emp a
3 ) temp
4 /
EMPNO ENAME JOB MGR HIREDATE SAL COMM DEPTNO (SELECTCOUNT(*)FROMEMP)
----- ---------- --------- ----- ----------- --------- --------- ------ -----------------------
7369 SMITH CLERK 7902 1980-12-17 800.00 20 14
7499 ALLEN SALESMAN 7698 1981-2-20 1600.00 300.00 30 14
7521 WARD SALESMAN 7698 1981-2-22 1250.00 500.00 30 14
7566 JONES MANAGER 7839 1981-4-2 2975.00 20 14
7654 MARTIN SALESMAN 7698 1981-9-28 1250.00 1400.00 30 14
7698 BLAKE MANAGER 7839 1981-5-1 2850.00 30 14
7782 CLARK MANAGER 7839 1981-6-9 2450.00 10 14
7788 SCOTT ANALYST 7566 1987-4-19 3000.00 20 14
7839 KING PRESIDENT 1981-11-17 5000.00 10 14
7844 TURNER SALESMAN 7698 1981-9-8 1500.00 0.00 30 14
7876 ADAMS CLERK 7788 1987-5-23 1100.00 20 14
7900 JAMES CLERK 7698 1981-12-3 950.00 30 14
7902 FORD ANALYST 7566 1981-12-3 3000.00 20 14
7934 MILLER CLERK 7782 1982-1-23 1300.00 10 14
14 rows selected