목록회원분석 (1)

3초기억력

MS-SQL SubString으로 할수있는 연령대별 회원분석 쿼리문

SELECT age_name, sex_name, SUM(total_count) AS total_count FROM ( SELECT CASE WHEN CAST(substring(CAST(CONVERT(varchar(10), getdate(), 121) AS varchar(10)), 1, 4) AS int) - CAST('19' + substring(jumin, 1, 2) AS int) + 1 BETWEEN 0 AND 20 THEN '20' WHEN CAST(substring(CAST(CONVERT(varchar(10), getdate(), 121) AS varchar(10)), 1, 4) AS int) - CAST('19' + substring(jumin, 1, 2) AS int) + 1 BETWEEN 2..
쿼리_MSSQL 2008. 11. 13. 18:01
이전 Prev 1 Next 다음