Using IN clause in sql server

Question

My query is like below.I want to select values if Type = 1 and subtype = 1,3 or 2.

select sum(case when Type = 1 and  SubType in (1, 3 or 2) then 1 else 0 end) as 'WorkStations'

Is this right way?

Answer 1

Since you're only trying to get a count of the workstations that meet the criteria as far as I can see:

SELECT COUNT(*) AS Workstations FROM MyWorkStationTable WHERE Type = 1 AND SubType IN (1, 2, 3)

Also, an IN clause is by nature already an OR. It is neither valid syntax nor necessary to state it.