Re: [SQL ] Like 後的count計算

[bohei (run and fall)]

2.
SELECT ID,COUNT(*) FROM (SELECT ID FROM tab WHERE ItemNum LIKE '%60001%'
                          UNION ALL
                         SELECT ID FROM tab WHERE ItemNum LIKE '%60003%'
                          UNION ALL
                         SELECT ID FROM tab WHERE ItemNum LIKE '%60005%')
  GROUP BY ID

不知還有沒有更精簡的寫法,還請大家指教,謝謝!

--
※ 發信站: 批踢踢實業坊(ptt.cc) 
◆ From: 61.221.42.225
推 CGS0:用 or 取代 union