We've expanded our news coverage and improved our search! Visit news.oreilly.com for the latest or search for all things across O'Reilly!
advertisement

Article:
  SQL Subqueries
Subject:   Subquery
Date:   2006-04-05 21:18:52
From:   paul21_7
Response to: Subquery

SELECT
COUNT(SELECT 1 FROM emp WHERE comm IS NULL) AS null_count,
COUNT(SELECT 1 FROM emp WHERE comm IS NOT NULL) AS not_null_count
FROM dual


enjoy!
Full Threads Oldest First

Showing messages 1 through 1 of 1.

  • Subquery
    2006-06-21 00:49:04  JustQuery [Reply | View]

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