nutz拼接条件时有没有随机rand排序的固定写法，select * from xx order by rand()

select GROUP_CONCAT(id),teq.competence from talent_evalution_questions teq
where teq.competence in('xxx1','xxx2')
GROUP BY teq.competence
order by RAND();

wendal

1楼•2430天前

用自定义SQL或者new Static写条件

请先登陆