select count(*) from ( select qi,r1 as r from 我有一个双色球每期开出的号码表 union all select qi,r2 as r from 我有一个双色球每期开出的号码表 union all select qi,r3 as r from 我有一个双色球每期开出的号码表 union all select qi,r4 as r from 我有一个双色球每期开出的号码表 union all select qi,r5 as r from 我有一个双色球每期开出的号码表 union all select qi,r6 as r from 我有一个双色球每期开出的号码表 ) t where r=4
select qi,r1 as r from 我有一个双色球每期开出的号码表
union all
select qi,r2 as r from 我有一个双色球每期开出的号码表
union all
select qi,r3 as r from 我有一个双色球每期开出的号码表
union all
select qi,r4 as r from 我有一个双色球每期开出的号码表
union all
select qi,r5 as r from 我有一个双色球每期开出的号码表
union all
select qi,r6 as r from 我有一个双色球每期开出的号码表
) t where r=4