Article:
  SQL Subqueries
Subject:   Subquery
Date:   2006-06-21 00:49:04
From:   JustQuery
Response to: Subquery

select Count(comm) null_count,count(*)-count(comm)not_null_count from emp