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
SebuturnAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
lwadwellConnect With a Mentor Commented:
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
 
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
All Courses

From novice to tech pro — start learning today.