MySQL ORDER BY rand()，名称 ASC

作者: 生活就是生下来就要干活
来源: 51数据库
2022-11-01

问题描述

我想以一个数据库为例，1000 个用户并选择 20 个随机用户(ORDER BY rand(),LIMIT 20)然后按以下顺序对结果集进行排序名字.我想出了以下查询，但没有像我希望的那样工作.

I would like to take a database of say, 1000 users and select 20 random ones (ORDER BY rand(),LIMIT 20) then order the resulting set by the names. I came up with the following query which is not working like I hoped.

SELECT * FROM users WHERE 1 ORDER BY rand(), name ASC LIMIT 20

推荐答案

使用子查询:

SELECT * FROM 
(
    SELECT * FROM users ORDER BY rand() LIMIT 20
) T1
ORDER BY name

内部查询随机选择 20 个用户，外部查询按名称对所选用户进行排序.

The inner query selects 20 users at random and the outer query orders the selected users by name.

推荐阅读

热点文章