如果 有人一下注 2,4,6,8,10,12 ---1注 6個號碼 如在1000筆中 找出 6個全中的 很簡單 但是要找出 只中5個號碼的 ..Sql 有法子做的到嗎 您就像個小孩子,世界上最遙遠的愛情就是我在你面前你卻不知道我愛你(小懷子)http://www.mm520.net

Hi ticky,

if 投注與選號為 1 => N    select  h.id,
        count(*)
from    選號檔 l,
        投注檔 h
where   h.id = l.id
and     l.號碼 in (2,4,6,8,10,12)
having count(*) = 5    if 投注與選號為 1 => 1 (SQL Server)    select  x.id,
        x.n1,
        x.n2,
        x.n3,
        x.n4,
        x.n5,
        x.n6,
        (nn1  nn2   nn3  nn4   nn5   nn6) bingo
from   (select t.id,
               t.n1,
               t.n2,
               t.n3,
               t.n4,
               t.n5,
               t.n6,
               case
                 when n1 in (2,4,6,8,10,12) then 1
               else 0
               end as nn1,
               case
                 when n2 in (2,4,6,8,10,12) then 1
               else 0
               end as nn2,
               case
                 when n3 in (2,4,6,8,10,12) then 1
               else 0
               end as nn3,
               case
                 when n4 in (2,4,6,8,10,12) then 1
               else 0
               end as nn4,
               case
                 when n5 in (2,4,6,8,10,12) then 1
               else 0
               end as nn5,
               case
                 when n6 in (2,4,6,8,10,12) then 1
               else 0
               end as nn6
        from   table1 t) x
where  (nn1  nn2   nn3  nn4   nn5   nn6)  = 5

---------------------------------- 小弟才疏學淺，若有謬誤尚請不吝指教 ----------------------------------

------
Fishman