作者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