Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Number of Distinct Users

Saumyadip Sarkar-OracleDec 30 2013 — edited Dec 30 2013

I have the following table

UsersRegion
S.SARKAR@CLE.COMEMEA
SSA.KUMAR@CLE.COMAPAC
SSA.KUMAR@CLE.COMAPAC
BHAR@CLE.COMEMEA
BIKRAM@CLE.COMEMEA
ANITA@CLE.COMLAD
ANITA@CLE.COMLAD
POOJA@CLE.COMEMEA
POOJA@CLE.COMEMEA
KAVYASHREE@CLE.COMEMEA

I have to find out number of Distinct User per region.

So the result will give me EMEA - 5

                                     APAC - 1

                                     LAD - 1

Can anyone help me with the query?
This post has been answered by Frank Kulash on Dec 30 2013
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jan 27 2014
Added on Dec 30 2013
4 comments
357 views