解决方法
这实际上是一个
duplicate question,但我现在有一个更好的,单通,快速,答案：
@H_404_19@Select *
from
(
SELECT tbl.*,@counter := @counter +1 counter
FROM (select @counter:=0) initvar,tbl
ORDER BY ordcolumn
) X
where counter <= (50/100 * @counter);
ORDER BY ordcolumn
