selecting count values for

antubis · #1 (**permalink**) 02-28-06, 09:00

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

hyperbole · #2 (**permalink**) 02-28-06, 11:10

use GROUP BY.

.

macjoubert · #3 (**permalink**) 02-28-06, 16:14

Quote:

Originally Posted by antubis

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

Try this

Code:

 SELECT A.BUILDING,COUNT(A.BUILDING) AS COUNTS FROM TABLE A 
     WHERE A.BUILDING NOT NULL
     GROUP BY BUILDING
     ORDER BY COUNTS DESC;

Internet Services

Web Development

Digital Marketing

Consumer Tech