Home Forums SQL Server 2005 T-SQL (SS2K5) tsql query for counting a 'grouped by' and a where clause RE: tsql query for counting a 'grouped by' and a where clause

  • however... what seems to be harder to do is list data which has a count = 0 or <1.

    e.g. we would also like to show which employers do not have a superuser.

    But this isn't possible to show here because if there are no superusers in the 'group by' results - then they are not listed in the first place to count, so it always returns none.