Archive

Posts Tagged ‘count based in condition’

SQL: Condition in Count()

July 7, 2015 1 comment

Condition in count()

SELECT
count(case when EventTypeID =1 then 1 else null end) as TotalTournamentsAttended,
count(case when EventTypeID =2 then 1 else null end) as TotalLeaguesAttended

FROM

[Tables]