MySQL：限制为记录量的百分比吗？

我发现的最佳答案：

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更改为其他百分比。