Is it possible to specify a condition in Count()? I would like to count only the rows that have for example "Manager" value in Position column.
Edit: please read carefully, I want to do it IN count statement, not using WHERE; I'm asking about it because I need to count both Managers and Other in the same select (something like Count(Position = Manager), Count(Poisition = Other)) so WHERE is no use for me in this example