Question

sql语句转Hql语句

select ROW_NUMBER() OVER (ORDER BY Code) from user 语句中的ROW_NUMBER() 在hql中能用吗 hql该怎么写

Answer 1

hql不支持复杂的sql，over()应该是不支持的

Answer 2

select gjc.guanjianci,count(gjc.wenzhang_id) as count from (select gjc.guanjianci,gjc.wenzhang_ID from KeyWord gjc,Article wz where (wz.biaoti_