我发现的最佳答案：
SELECt*FROM ( SELECt list.*, @counter := @counter +1 AS counter FROM (select @counter:=0) AS initvar, list ORDER BY value DESC ) AS Xwhere counter <= (10/100 * @counter);ORDER BY value DESC
将10更改为其他百分比。
我发现的最佳答案：
SELECt*FROM ( SELECt list.*, @counter := @counter +1 AS counter FROM (select @counter:=0) AS initvar, list ORDER BY value DESC ) AS Xwhere counter <= (10/100 * @counter);ORDER BY value DESC
将10更改为其他百分比。
名师互学网 版权所有 (c)2021-2022 ICP备案号：晋ICP备2021003244-6号
