MSSQL – 회원들의 email provider를 뽑고 싶을때
다음에 또 치기 싫으니-_-;;
올려놔야지.. ㅋ
select substring(email, (charindex(‘@’, email)+1), (len(email)-charindex(‘@’, email)+1)) as ‘mail providers’,
count([id]) as ‘회원수’
from [회원DB] with (NOLOCK)
group by substring(email, (charindex(‘@’, email)+1), (len(email)-charindex(‘@’, email)+1))
이걸로 큰 귀찮음을 덜 수 있다면 다행!