1到11里面选1个,12到22里面选1个,23到33里面选1个,然后再随机选3个。
组合数 =COMBIN(33,6)-3COMBIN(22,6)+3COMBIN(11,6)=885115
sql计算如下:
WITH RECURSIVE t(a) AS (SELECT 1
UNION SELECT a+1 from t where a<33
)
SELECT count(*) FROM t a, t b, t c, t d , t e , t f
where a.a<b.a
and b.a<c.a
and c.a<d.a
and d.a<e.a
and e.a<f.a
and a.a BETWEEN 1 and 11
and f.a BETWEEN 23 and 33
and(b.a BETWEEN 12 and 22
or c.a BETWEEN 12 and 22
or d.a BETWEEN 12 and 22
or e.a BETWEEN 12 and 22
)