Reply to Re: SQL Counting number of non-distinct rows?
Posted by --CELKO-- on 05/03/06 19:55
Please post DDL, so that people do not have to guess what the keys,
constraints, Declarative Referential Integrity, data types, etc. in
your schema are. There is no key here, for example, so it is BY
DEFINITION not a table at all!
SELECT r1, COUNT(*) AS r1_tally
FROM Foobar
GROUP BY r1;