Pull random records

cowannbell

New member
Local time
Today, 16:24
Joined
Dec 8, 2005
Messages
5
I have a table that has names and address and an address number. There are multiple address numbers but the names may be different. I only need one record for each address number and it doesn't matter which name i pulls. How can I accomplish this.


Thanks,
 
If it doesn't really matter which names is pulled, then just pull the first one. ;)

Select Address, FIRST(Name) AS Name
FROM your_table
GROUP BY Address
 
I'm confused on this part. I need to pull the entire record but only one per address #.

Select Address, FIRST(Name) AS Name

The field name of the Address is address#.

Are you saying it should look like this:

SELECT [(Grp AZ & CO Providers)].*, FIRST [Address #] AS Address #
FROM [(Grp AZ & CO Providers)]
GROUP BY [Address #]
 

Users who are viewing this thread

Back
Top Bottom