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
不知还有没有更精简的写法,还请大家指教,谢谢!

用 or 取代 union