SQL Lanquage

[Guest]

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.

 

[Gary B]

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.

how about...

select DISTINCT CustomerID, CustomerName from Customers

or

select CustomerID, CustomerName from Customers group by CustomerID

 

[Guest]

The select distinct will work for this.

 

[Guest]

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