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;