• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 581
  • Last Modified:

How to select only the first match ?

I have a table with loads of duplicates (not real ones, but like with a "-" in one and not in an other etc ...)

So, the comapy names are differents, but the phone number is the same.

I would like to create a querry that only take the first match for each phone number, and leave the other ones ... so i only have 1 company by phone number ...


Thanks
0
Sebuturn
Asked:
Sebuturn
1 Solution
 
GDECommented:
In oralce it`s be, for example,
select * from your_table where rownum<2

Best regards
Dmitry.
0
 
SebuturnAuthor Commented:
Oh yeah .. i m using access
0
 
lwadwellCommented:
what do you really mean by 'first match'...if you did a 'group by phone_number' and select 'max(company_name)' or 'min(company_name)' you will get only one company by phone number...
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Network Scalability - Handle Complex Environments

Monitor your entire network from a single platform. Free 30 Day Trial Now!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now