;
- Original Message -
From: "Csaba Gabor" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, June 07, 2002 10:20 AM
Subject: Counting distinct elements
> Seems like this should be an easy question, but I just don't get it:
>
> If I have CREATE TABLE Elems (
You mean
SELECT ObjId,ElemId,count( distinct Objid,ElemId ) from Elems group by
ObjId;
?
Csaba Gabor wrote:
>Seems like this should be an easy question, but I just don't get it:
>
>If I have CREATE TABLE Elems (ObjId INT, ElemId INT);
>Is there a nice query to find the Number of Distinct Ele
Seems like this should be an easy question, but I just don't get it:
If I have CREATE TABLE Elems (ObjId INT, ElemId INT);
Is there a nice query to find the Number of Distinct ElemId's for each ObjId?
Motivation: Later I will want to add a WHERE ObjId IN (...) and join the Obj
describing table
