Posts

Showing posts from January, 2017

How to get count of distinct column in ORACLE

select   DISTINCT COL_NAME_1,count( DISTINCT COL_NAME_2) as COUNT from TABLE_NAME   group by COL_NAME_1 ;