sql的jpa 2.0条件api表达式减 [英] jpa 2.0 criteria api expression for sql minus

问题描述

如何创建与sql减号语句等效的jpa Criteria表达式

How do you create a jpa Criteria expression that is equivalent to the sql minus statement

示例

  SELECT mod_code
  FROM SRS.Table1
MINUS
  SELECT mod_code
  FROM SRS.Table2;

推荐答案

减号不存在，但您可以这样做：

Minus does not exist but you can do something like that:

select t1.mod_code from Table1 t1 where not exists 
(select t2 from table2 t2 where t2.mode_code = t1.mode_code)

这篇关于sql的jpa 2.0条件api表达式减的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！