selecting distinct rows amongst composite values

newimmigrant · #1 (**permalink**) 10-18-05, 06:26

So i have an addressbook table which has the following fields
srNo, Name, Address, City, State, Zip, Phone

A number of entries have been entered more than once. the pr key is srNo.

So there is an entry #1 having the values
Person1, Address1,City1,State1,Zip1,Phone1

There is another entry at #10 having values
Person1, Address1,City1,State1,Zip1,Phone1

So how do I pull up distinct rows which checks across ALL fields such that the row above comes up only once?

thank you

tombell · #2 (**permalink**) 10-18-05, 06:36

Code:

SELECT 
 Name,
 Address,
 City,
 State,
 Zip,
 Phone
FROM
 table
GROUP BY
Name,
 Address,
 City,
 State,
 Zip,
 Phone

newimmigrant · #3 (**permalink**) 10-18-05, 13:19

thanks a lot. that worked

Internet Services

Web Development

Digital Marketing

Consumer Tech