티스토리 뷰

공부

[SQL] Count by condition

seunggabi 승가비 2019. 12. 22. 00:15
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

'공부' 카테고리의 다른 글

[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
댓글
댓글쓰기 폼
공지사항
최근에 달린 댓글
Total
28,468
Today
5
Yesterday
49
«   2020/02   »
            1
2 3 4 5 6 7 8
9 10 11 12 13 14 15
16 17 18 19 20 21 22
23 24 25 26 27 28 29
글 보관함