Count occurrences of distinct values whilst returning the distinct values, MySQL

Count occurrences of distinct values whilst returning the distinct val...

Language: Layout:


absolute service time: 0,4 sec

edit mode | history

  
id
name
cnt

1
1
Mark
2

2
2
Mike
3

3
3
Paul
1

4
4
Mike
3

5
5
Mike
3

6
6
John
1

7
7
Mark
2

λ

                                      .NET NoSQL database for rapid development