| Subject | COUNT DISTINCT on a composite key |
|---|---|
| Author | Robert DiFalco |
| Post date | 2003-05-01T23:44:23Z |
I was wondering how to perform a distinct count when my table has a
composite primary key. I naively thought something like this might work:
SELECT COUNT( DISTINCT keyColumn1, keyColumn2 ) ....
R.
[Non-text portions of this message have been removed]
composite primary key. I naively thought something like this might work:
SELECT COUNT( DISTINCT keyColumn1, keyColumn2 ) ....
R.
[Non-text portions of this message have been removed]