初级问题:建表 CREATE TABLE TABLE2AS SELECT CUST_ID,SUM(FEE) FEE,FROM TABLE1group by cust_idORDER BY FEE; 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 还是报错在第五行:missing expression CREATE TABLE TABLE2AS SELECT CUST_ID,SUM(FEE) FEEFROM TABLE1group by cust_idORDER BY FEE;多了一个, CREATE TABLE TABLE2AS SELECTCUST_ID,SUM(FEE) FEEFROM LEIJQ_CDMA_200403GROUP BY CUST_ID,ORDER_BY FEE报错SQL command not properly ended 加分号没有?还有,是order by,不是order_by CREATE TABLE TABLE2AS SELECTCUST_ID,SUM(FEE) FEEFROM LEIJQ_CDMA_200403GROUP BY CUST_ID,ORDER BY FEE这些小错误,自己看一眼就知道了 CREATE TABLE TABLE2AS SELECTCUST_ID,SUM(FEE) FEEFROM TABLE2GROUP BY CUST_ID,ORDER BY FEE;分号加了报错:ERROR at line 7:missing expression 楼上的错误还没解决啊,郁闷ing SQL>CREATE TABLE TABLE2 AS SQL>SELECT CUST_ID,SUM(FEE) FEESQL>FROM TABLE1SQL>GROUP BY CUST_IDSQL>ORDER BY FEE; CREATE TABLE TABLE2AS SELECTCUST_ID,SUM(FEE) FEEFROM TABLE1GROUP BY CUST_ID,ORDER BY FEE;报错:ERROR at line 7:missing expression 哎!好端端的又加什么,CREATE TABLE TABLE2AS SELECTCUST_ID,SUM(FEE) FEEFROM TABLE1GROUP BY CUST_IDORDER BY FEE; 先建一张视图,CREATE VIEW aa AS SELECT CUST_ID,FEE FROM TABLE1 GROUP BY CUST_ID;然后根据视图建表。我是一个新手,学pl/sql才一个月,不知这样可以吗? 将下面的语句Copy回去直接运行:CREATE TABLE TABLE2 AS SELECT CUST_ID,SUM(FEE) FEEFROM TABLE1GROUP BY CUST_IDORDER BY FEE CREATE TABLE table2 AS SELECT CUST_ID, sum(fee) FEE FROM TABLE1 GROUP BY cust_id ; 不要用create table as 我在华为面试的时候,他们居然问我有create table as 这样的语句么?能编译过去么?唉,我晕 EPM@ERP SQL中 WHERE 后 LIKE %(select语句)% 求救~!高手请进 请教:在一个已使用的数据表中增加字段是否会降低数据库写库的效率呢? 表空间备份,对数据备份了么? 一个关于STANDBY数据库的问题! oracle9i中如何永久性修改serveroutput参数为on oracle9i+linux8.0 proc的配置,疯了,怎么设置啊,到底,感谢!!!!! 向各位请教 Oracle中如何查询同一字段下,另一字段相近的记录? 请教:如何获得最近一次操作所影响的行数。 在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
;