Thread: Count and Intersect

Count and Intersect

From
Michaël Fiey
Date:
Hi,

Is it possible to count the number of rows returned by a command which use
the intersect operator,
such as :

SELECT col1 as my_col
FROM table
WHERE <conditions 1>
INTERSECT
SELECT col1 as my_col
FROM table
WHERE <conditions 2>
INTERSECT
SELECT col1 as my_col
FROM table
WHERE <conditions 2>

Any help would be appreciated.

Regards
michael