티스토리 뷰
728x90
select count(case Position when 'Manager' then 1 else null end)
from ...
select sum(case Position when 'Manager' then 1 else 0 end)
from ...[출처] https://stackoverflow.com/questions/1400078/is-it-possible-to-specify-condition-in-count
728x90
'공부' 카테고리의 다른 글
| [Linux] Encoding 깨질때 (0) | 2020.01.18 |
|---|---|
| [FTP] command (0) | 2019.12.22 |
| [SQL] Count by condition (0) | 2019.12.22 |
| [JS] VueJS bind scroll event (0) | 2019.12.22 |
| [JS] Browser get scroll direction (0) | 2019.12.22 |
| [Git] How do I get the commit count? (0) | 2019.12.22 |
댓글