select * from cgccy_shipbasic_registstats where ship_name in(
select ship_name from cgccy_shipbasic_registstats group by ship_name having count(*)>1
) or ship_no in (
select ship_no from cgccy_shipbasic_registstats group by ship_no having count(*)>1
) order by ship_name,ship_no
这句话在hibernate中执行不了 怎么转换下那
select ship_name from cgccy_shipbasic_registstats group by ship_name having count(*)>1
) or ship_no in (
select ship_no from cgccy_shipbasic_registstats group by ship_no having count(*)>1
) order by ship_name,ship_no
这句话在hibernate中执行不了 怎么转换下那
不过你要用createQuery()的方法的话,你需要把表的名字写成对象的名字,字段也是对象的属性。不能直接select * from .....;要么就 from ......就好了,要么就 select 属性1,属性2 from .....