How to get count of distinct column in ORACLE Get link Facebook X Pinterest Email Other Apps January 08, 2017 select DISTINCT COL_NAME_1,count( DISTINCT COL_NAME_2) as COUNT from TABLE_NAME group by COL_NAME_1 ; Read more