Re: [SQL ] Like 後的count計算
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
推
02/03 20:59, , 1F
02/03 20:59, 1F
討論串 (同標題文章)
完整討論串 (本文為第 2 之 2 篇):