以独特的MySQL方式：
select *from ( select * , @rn := @rn + 1 as rn from Table1 join (select @rn := 0) i ) swhere rn mod 2 = 0 -- Use = 1 for the other set
SQL Fiddle中的示例。
以独特的MySQL方式：
select *from ( select * , @rn := @rn + 1 as rn from Table1 join (select @rn := 0) i ) swhere rn mod 2 = 0 -- Use = 1 for the other set
SQL Fiddle中的示例。
名师互学网 版权所有 (c)2021-2022 ICP备案号：晋ICP备2021003244-6号
