解决方法
这实际上是一个
duplicate question,但我现在有一个更好的,单通,快速,答案：
- 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
