开发者

Oracle report union operator

开发者 https://www.devze.com 2023-04-04 05:33 出处:网络
How can I get the result of only First Query when the开发者_开发知识库 condition in the First Query satisfies in a query like Q1 Union Q2.If I understand your question correctly, then:

How can I get the result of only First Query when the开发者_开发知识库 condition in the First Query satisfies in a query like Q1 Union Q2.


If I understand your question correctly, then:

Q1
UNION
Q2 WHERE NOT EXISTS(Q1)

That is, you write Q2 so that it never returns anything if Q1 returns any rows.

0

精彩评论

暂无评论...
验证码 换一张
取 消