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
|
||
Showing messages 1 through 1 of 1.
-
Subquery
2006-06-21 00:49:04 JustQuery [View]
select Count(comm) null_count,count(*)-count(comm)not_null_count from emp
