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;

Comments

Popular posts from this blog

Spring MVC- Redirect from one controller to another

Integrating Struts2 with Spring Security using Custom Login Form