CODEWITHSUNDEEP
sqloracle-database
Bharath
Bharath

Reputation: 195

Count of distinct rows and with one from duplicates-Oracle

My column values

CustomerID
-----------
44468111
44468112
44468113
44468112
44468112

I need Count of total Customer ID's Not Disctinct.

Excpected Output:

Count(CustomerID's)
-------------------
3

Can you please help me out to get this. I am a newbie. Thanks in Advance..!!! :)

Upvotes: 0

Views: 59

Answers (1)

Gordon Linoff
Gordon Linoff

Reputation: 1269693

Well, if you want 3, then you do want distinct:

select count(distinct CustomerID)

Upvotes: 1

Related Questions