×
INTELLIGENT WORK FORUMS
FOR ENGINEERING PROFESSIONALS

Log In

Come Join Us!

Are you an
Engineering professional?
Join Eng-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

selecting 1 instance of duplicate records

selecting 1 instance of duplicate records

selecting 1 instance of duplicate records

(OP)
Ok. Here's the problem: I have a table with duplicate data in a table (see example below). I want to select the record only once instead of the multiple times that it occurs. The problem is that I can't make a specific select statement for each individual number because the table has 70000 records. I hope this is clear.

Field1     Field2
1          1
1          2
1          3
1          4
1          5
2          1
2          2
2          3
3          1
3          2
3          3

To further elaborate, what I want is to select from Field1 1 once, 2 once and 3 once. Is there a way to do this?? Any help would be greatly appreciated.

RE: selecting 1 instance of duplicate records

Dear WakeUpDeadMan,

The DISTINCT caluse will solve your problem.

That is
SELECT DISTINCT FIELD1 FROM <tablename>

In case of detailed explanation please feel free to mail me at simp_raman@rediffmail.com

RE: selecting 1 instance of duplicate records

(OP)
i want to select duplicate records only in database

Can u pls help

RE: selecting 1 instance of duplicate records

Hi, Kujar

This SQL query will give you the duplicate records in the particulat table:

 select *  from  <Tabname>a
where    rowid < (
         select  max(rowid)
         from    <Tabname>b
         where   b.location_nam = a.location_nam
         
        )

In case of any confusion feel free to ask.

Regards,
Aakash

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Eng-Tips Forums free from inappropriate posts.
The Eng-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Eng-Tips forums is a member-only feature.

Click Here to join Eng-Tips and talk with other members!


Resources