====== Oracle - SQL - Count - Count Distinct ======

<code sql>
SELECT COUNT(*) 
FROM (
SELECT DISTINCT clo1,col2,col3
FROM Schema.Table
WHERE Column = 'Y');
</code>