Question

求帮忙sql语句转换成hql语句

SELECT
*
FROM
Brand AS b1
JOIN (
SELECT
ROUND(
RAND() * (
(SELECT MAX(id) FROM Brand) - (SELECT MIN(id) FROM Brand)
) + (SELECT MIN(id) FROM Brand)
) AS id_1
) AS b2
WHERE
b1.id >= b2.id_1
LIMIT 1

用 navicat 输入这个sql语句的作用时在表里随机获取一条不连续的数据,求转换成hql 因为我是用hibernate的,然而在java代码里不想用createSQLQuery() ,, 必须用createQuery() 求帮忙转换HQL 要成功的啊 用是的mysql 图片里的sql语句代码是成功获取的

Answer 1

select * from (select * from questionlog order by score desc) as t group by usercode order by score desc
如果除了usercode 还有其它字段，肯定会出错的，而且我肯定不只有这个字段，因为还有score 。
不在GROUP BY 後面的字段，要在汇总函数裏面