Simple SQL Distinct...!?

From: "@sh" <spam@xxxxxxxx>
Date: Mon, 27 Feb 2006 14:29:22 +0000 (UTC)

This may be a really simple question, but I always have problems with
Distinct queries.

In this instance, I have a table of Delivery addresses, some will be exactly
the same EXCEPT for the DeliveryID field, but eitherway I need the
DeliveryID so that I can pass it onto the next form.

So, I need to run a query that will find only addresses that are unique
whilst retaining the respective DID for the rows...

SELECT DISTINCT DeliveryID, Address, Organisation, Organisation, Town,
County, PostCode FROM SOL_Delivery WHERE CustomerID = 15)

How do I adjust the following to only 'Distinct' the fields other than the
DeliveryID?

Thanks!

.

Follow-Ups:
- Re: Simple SQL Distinct...!?
  - From: David Portas
- Re: Simple SQL Distinct...!?
  - From: markc600
- Re: Simple SQL Distinct...!?
  - From: Tom Moreau

Prev by Date: Re: Linked Server SQL to SQL
Next by Date: Re: advice
Previous by thread: workgroup information file does not exist
Next by thread: Re: Simple SQL Distinct...!?
Index(es):
- Date
- Thread

Relevant Pages

Re: Simple SQL Distinct...!?
... the same EXCEPT for the DeliveryID field, ... DeliveryID so that I can pass it onto the next form. ... SELECT MIN, address, organisation, town, county, postcode ... State what version of SQL Server you are using and specify the content ...
(comp.databases.ms-sqlserver)
Re: Simple SQL Distinct...!?
... Columnist, SQL Server Professional ... Distinct queries. ... the same EXCEPT for the DeliveryID field, ... DeliveryID so that I can pass it onto the next form. ...
(comp.databases.ms-sqlserver)