select * from QUEUE a where EXISTS(select * from (
SELECT DINNER_CARD_NO,MAX(CREATE_TIME) newTime from QUEUE GROUP BY DINNER_CARD_NO)b
WHERE a.DINNER_CARD_NO = b.DINNER_CARD_NO AND a.CREATE_TIME = b.newTime
)and a.DINNER_CARD_NO = '111'
uj5u.com熱心網友回復:
HQL的陳述句和SQL是一樣的,只是說在HQL里的表名是個物件,需要在程式里配置轉載請註明出處,本文鏈接:https://www.uj5u.com/shujuku/90798.html
標籤:開發
