- Original Message -
From: "Claire Lee" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, August 03, 2004 11:28 AM
Subject: distinct based on two fields--please help
> I have a table like this
>
> name price type
> A10 1
From: Claire Lee [mailto:[EMAIL PROTECTED]
> I have a table like this
>
> name price type
> A10 1
> B30 2
> A20 1
> B20 2
>
> would like to distinct based on name and type, do a
> sum and get the following result
>
> name price type
> A
I have a table like this
name price type
A10 1
B30 2
A20 1
B20 2
would like to distinct based on name and type, do a
sum and get the following result
name price type
A 30 1
B 50 2
How do I do this with one sql qu
