CREATE TABLE TABLE2
AS SELECT
CUST_ID,
SUM(FEE) FEE,
FROM TABLE1
group by cust_id
ORDER BY FEE;
AS SELECT
CUST_ID,
SUM(FEE) FEE,
FROM TABLE1
group by cust_id
ORDER BY FEE;
解决方案 »
- 关于hibernate
- 下午被一问题卡住了:查询和“s001”号同学所学课程完全相同的其他同学的学号
- oracle 11g 安装之后启动database control异常 nmz.exe异常
- select name from student和select name from student where name='%%' 的区别?
- 帮忙推荐一个DBA吧~北京,美资,年薪20w
- index与主键冲突
- 我在weblogic 的日志里发现这个 OALL8 is in an inconsistent state
- 关于内连接的一些困惑
- 启动tnslinstener时出现:错误3,系统找不到指定路径
- 怎样知道某一个存储过程是否正在执行!!!!
- 请教:如何获得最近一次操作所影响的行数。
- 在oracle中如何实现像sql中top 5 *这个功能?
AS SELECT
CUST_ID,
SUM(FEE) FEE
FROM TABLE1
group by cust_id
ORDER BY FEE;多了一个,
AS SELECT
CUST_ID,
SUM(FEE) FEE
FROM LEIJQ_CDMA_200403
GROUP BY CUST_ID,
ORDER_BY FEE报错SQL command not properly ended
AS SELECT
CUST_ID,
SUM(FEE) FEE
FROM LEIJQ_CDMA_200403
GROUP BY CUST_ID,
ORDER BY FEE
这些小错误,自己看一眼就知道了
AS SELECT
CUST_ID,
SUM(FEE) FEE
FROM TABLE2
GROUP BY CUST_ID,
ORDER BY FEE;
分号加了
报错:ERROR at line 7:
missing expression
SQL>SELECT CUST_ID,SUM(FEE) FEE
SQL>FROM TABLE1
SQL>GROUP BY CUST_ID
SQL>ORDER BY FEE;
AS SELECT
CUST_ID,
SUM(FEE) FEE
FROM TABLE1
GROUP BY CUST_ID,
ORDER BY FEE;报错:ERROR at line 7:
missing expression
哎!好端端的又加什么,CREATE TABLE TABLE2
AS SELECT
CUST_ID,
SUM(FEE) FEE
FROM TABLE1
GROUP BY CUST_ID
ORDER BY FEE;
CREATE VIEW aa AS
SELECT CUST_ID,FEE
FROM TABLE1
GROUP BY CUST_ID;然后根据视图建表。
我是一个新手,学pl/sql才一个月,不知这样可以吗?
CREATE TABLE TABLE2 AS
SELECT CUST_ID,SUM(FEE) FEE
FROM TABLE1
GROUP BY CUST_ID
ORDER BY FEE
SELECT CUST_ID, sum(fee) FEE
FROM TABLE1
GROUP BY cust_id
;