Posted by markc600 on 05/03/06 19:47

I think this is what you want


SELECT R1,COUNT(*)
FROM(
SELECT DISTINCT R1,R2,R3
FROM mytable
) X
GROUP BY R1

• Next in forum: Re: Problem with using BETWEEN for date range...
• Prev in forum: SQL Counting number of non-distinct rows?
• Thread view: Re: SQL Counting number of non-distinct rows?

[Reply to this message]