SQL Lanquage

G

Gary

What would be a good book to learn more about SQL language and is there a
criteria that I could use to get just one result even though the item is
duplicated in the table that I am using.

Say customer 655153 is in a table 13 different times, how can I get that
customer in a query without duplicates?

Thanks for any help.
 
G

Gary B

Gary said:
What would be a good book to learn more about SQL language and is there a
criteria that I could use to get just one result even though the item is
duplicated in the table that I am using.

Say customer 655153 is in a table 13 different times, how can I get that
customer in a query without duplicates?

Thanks for any help.
Click to expand...

how about...

select DISTINCT CustomerID, CustomerName from Customers

or

select CustomerID, CustomerName from Customers group by CustomerID
 
G

Gary

Would that work on multiple customers or just that one? If just that one, is
there a way to distinct multiple customers?
 
Top