Here is the problem
Table schema is:
ID, UID, BUILDING, TIME;
I want to count how many are rows contains some BUILDING with some value in a single query. I can`t explain it very good. See the example to understant what i want.
EXAMPLE
1, 2, 0, some time;
2, 2, 0, some time;
3, 2, 0, some time;
4, 2, 1, some time;
5, 2, 1, some time;
6, 2, 3, some time;
The query must return: 3 (O) AND 2 (1) AND 1 (3)
Thank you!
Marush Denchev