Re: Using DISTINCT AND SUM together SQL question
From: Cimarron Taylor <cimarron+google_at_taylors.org>
Date: 13 Apr 2002 01:17:37 -0700
Message-ID: <29e28c51.0204130017.30368061_at_posting.google.com>
Date: 13 Apr 2002 01:17:37 -0700
Message-ID: <29e28c51.0204130017.30368061_at_posting.google.com>
You don't need distinct. Just use a group by:
select item, rev, sum(qty)
from ...
group by 1, 2
Cim Received on Sat Apr 13 2002 - 10:17:37 CEST