問題描述
我正在嘗試使用 FETCH FIRST 1 ROW 在 SQL 中創(chuàng)建一個 UNION ALL 語句，但是當(dāng)我這樣做時，它給了我一個錯誤 MISSING KEYWORD
I'm trying to create a UNION ALL statement in SQL using the FETCH FIRST 1 ROW however when I do that it gives me an error MISSING KEYWORD
這是我的 SQL 的樣子:
Here's what my SQL looks like:
Select * From tabl1 where Date = '04-MAR-2020' FETCH FIRST 1 ROW
UNION ALL
Select * From tabl1 where Date = '05-MAR-2020' FETCH FIRST 1 ROW
是這樣可行的.我希望將其保留為單個語句，而不是添加 SUBQUERY 或任何此類性質(zhì)的內(nèi)容.
is something like this doable. I would like to keep this as a single statement rather than adding a SUBQUERY or anything of that nature.
推薦答案
只需將每個部分放在括號中即可.無論如何都可以在 12.2 中使用:
Just put the each part in parentheses. Works in 12.2, anyway:
( Select * From tabl1 where Date = '04-MAR-2020' FETCH FIRST 1 ROW )
UNION ALL
( Select * From tabl1 where Date = '05-MAR-2020' FETCH FIRST 1 ROW )
我的實(shí)際測試查詢，對于任何感興趣的人是這樣的:
My actual test query, for anyone interested was this:
(select object_name
from user_objects
where object_type = 'TABLE'
order by object_name
fetch first 1 row only)
UNION ALL
(select object_name
from user_objects
where object_type = 'VIEW'
order by object_name
fetch first 1 row only);
這篇關(guān)于Oracle FETCH FIRST 1 ROW with UNION ALL 語句的文章就介紹到這了，希望我們推薦的答案對大家有所幫助，也希望大家多多支持html5模板網(wǎng)！