我正在构造一个Hibernate标准,使用如下所示的子选择 DetachedCriteria.forClass(NhmCode.class, "sub"); // the subselect selecting the maximum 'validFrom'
subselect.add(Restrictions.le("validFrom", new Date())); //
我正在寻找一种基于子subselect在多个值上运行"locate“函数的方法;这是我所设想的伪代码(它不运行,因为子subselect返回多个值;这正是我想要的)。with cte_subselect as (select distinct field1 from subquery)
select * from table inner join cte_subselect