This topic is locked

Count The Distinct Values

5/31/2013 1:49:01 AM
PHPRunner General questions
A
adnankmk author

I have table Posting with the following details.
id (int)

Wing (varchar)

Status (bit)
The table has the following values
id wing Status

1 al 0

2 al 0

3 al 1

4 db 0

5 db 1

6 db 0

7 db 1
The result should be displayed as under
Wing filled vacant

al 1 2

db 2 2
What code should I use in reports to display the desired results.

Sergey Kornilov admin 5/31/2013

Google "<your database> count distint"
Here is an example for SQL Server:

http://blog.sqlauthority.com/2011/03/08/sql-server-difference-between-countdistinct-vs-countall/