作者bohei (run and fall)
看板Database
標題Re: [SQL ] Like 後的count計算
時間Tue Jan 21 17:51:25 2014
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
1F：推 CGS0:用 or 取代 union 02/03 20:59