Hi Experts,
I need to create a query that will return me all the unique records based on few fields. I am gonna try to explain by example.
here is a table with few columns :
Table name : Contact
Fields name: Company, Address 1, address 2, City, State, district #
Company Adress1 address 2 city state distric #
abc 124 street 222 door Miami FL #03
abc 123 street 222 door Miami FL #04
abc 123 street 222 door Miami FL #02
abc 123 street 222 door Miami FL #03
abc 123 street 222 door Miami FL #04
abc 123 street 222 door Miami FL #03
abc 123 street 222 door Miami FL #03
the output will be
abc 124 street 222 door Miami FL #03
abc 123 street 222 door Miami FL #04
abc 123 street 222 door Miami FL #02
abc 123 street 222 door Miami FL #03
I would like a query that will show me all the unique company based on the fields : company , address 1 and district#.
I am trying to figure out how many unique company exists in a single district and have each district unique company on their own table.
Can someone help me ?
Thanks
Our community of experts have been thoroughly vetted for their expertise and industry experience.
The Distinguished Expert awards are presented to the top veteran and rookie experts to earn the most points in the top 50 topics.