mikestan
asked on
Need help reporting distinct records with count
I would like to run a quick report that goes through a given table and reports all the duplicate records with a count of each one using sqlplus. Here's some sample data:
ID
-----
12
10
11
8
8
8
8
12
9
This should return a report something like:
ID COUNT
----- ------------
8 4
9 1
10 1
11 1
12 1
Can someone show me the query that can accomplish this?
ID
-----
12
10
11
8
8
8
8
12
9
This should return a report something like:
ID COUNT
----- ------------
8 4
9 1
10 1
11 1
12 1
Can someone show me the query that can accomplish this?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.