Re: [SQL] Query for duplicates.

On Thu, 5 Aug 1999, Matthew Hagerty wrote:
> I found myself in an unusual situation today. I need a query to display
> only customers with addresses that appear more than once. Usually I am
> having to get unique addresses, etc. at which I have become very good, but
> this one is giving me a run for.
> What I need is something like this:
> create table customer (
> custdate date,
> name varchar(30),
> address varchar(30),
> city varchar(20),
> state varchar(2),
> zip varchar(10));
> select address,city,state,zip from customer
> where custdate<='05-30-1999'
> group by address having count(address)>1;

select address,city,state,zip from customer
where custdate<='05-30-1999'
group by address,city,state,zip
having count(*)>1;

____________________}John Flinchbaugh{______________________
| -> glynis(at)hjsoft(dot)com <- john(at)cs(dot)millersv(dot)edu |
| glynis(at)netrax(dot)net http://www.hjsoft.com/~glynis/ |
~~Powered by Linux: Reboots are for hardware upgrades only~~