rt_case_when.md

Show ResultSet Types：case_when

oracle

SELECT
COUNT( CASE WHEN AGE = 18 THEN 'countof18' END) EIGHTENN,
COUNT( CASE WHEN AGE = 19 THEN 'countof19' END) NINETEEN
FROM
PeopleInfo

显示前：

显示后：