Skip to Content

0

Former Member

Aug 29, 2014 at 12:22 AM

How to create a view with a column of counts of the occurence of values

511 Views

If my table is:

ID

1

2

3

3

5

5

5

I want to create a view with the following result:

ID COUNT

1 1

2 1

3 2

5 3

How would I accomplish this?