How to use EXCEPT or INTERSECT with QueryDSL

已查看 321 次
跳至第一个未读帖子

google...@sql-workbench.net

未读,
2016年11月28日 08:35:532016/11/28
收件人 Querydsl
Using UNION or UNION ALL is straightforward with QueryDSL (SQL).

But I can't find a way to use the EXCEPT or INTERSECT operators:

select a,b from table_one
except
select x,y from table_two;

(except is standard SQL - in Oracle that would be MINUS - but I didn't find that either)

The same is true for the INTERSECT operator:

select a,b from table_one
intersect
select x,y from table_two;

Is this simply not possible or am I missing something obvious?

Bonus question: if it is possible, how can I distinguish between EXCEPT and EXCEPT ALL?

回复全部
回复作者
转发
0 个新帖子