CREATE OR REPLACE VIEW NOTE AS
(
SELECT A.INTF_ID
,A.CODE_GROUP_ID
,A.GROUP_KEY
,A.GROUP_NAME
,GROUP_VAL_TYPE
,B.CODE_VAL
,B.CODE_NOTE
,A.IS_FILTERED
FROM GROUP A,NOTE B
WHERE A.CODE_GROUP_ID=B.CODE_GROUP_ID
AND ROWNUM <= 100000
ORDER BY A.INTF_ID,A.GROUP_KEY,B.CODE_VAL
)
运行后总是报错,错在order by上,说什么缺失右括号。在线等!急急急
(
SELECT A.INTF_ID
,A.CODE_GROUP_ID
,A.GROUP_KEY
,A.GROUP_NAME
,GROUP_VAL_TYPE
,B.CODE_VAL
,B.CODE_NOTE
,A.IS_FILTERED
FROM GROUP A,NOTE B
WHERE A.CODE_GROUP_ID=B.CODE_GROUP_ID
AND ROWNUM <= 100000
ORDER BY A.INTF_ID,A.GROUP_KEY,B.CODE_VAL
)
运行后总是报错,错在order by上,说什么缺失右括号。在线等!急急急
CREATE OR REPLACE VIEW NOTE AS
select * from
(
SELECT A.INTF_ID
,A.CODE_GROUP_ID
,A.GROUP_KEY
,A.GROUP_NAME
,GROUP_VAL_TYPE
,B.CODE_VAL
,B.CODE_NOTE
,A.IS_FILTERED
FROM GROUP A,NOTE B
WHERE A.CODE_GROUP_ID=B.CODE_GROUP_ID
ORDER BY A.INTF_ID,A.GROUP_KEY,B.CODE_VAL
) where ROWNUM <= 100000
原来是这样的:
CREATE OR REPLACE VIEW V_D_CODE_NOTE AS
(
SELECT TOP 100000 A.INTF_ID
,A.CODE_GROUP_ID
,A.GROUP_KEY
,A.GROUP_NAME
,GROUP_VAL_TYPE
,B.CODE_VAL,B.CODE_NOTE
,A.IS_FILTERED
FROM GROUP A,NOTE B
WHERE A.CODE_GROUP_ID=B.CODE_GROUP_ID
ORDER BY A.INTF_ID,A.GROUP_KEY,B.CODE_VAL
)
老大们看看 这个和我上面写的是不是一样?因为这样写TOP 100000 处报错
不能用top 10000因为那是sqlserver的语法