selecting 1 instance of duplicate records

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.

 

[biosraman]

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

 

i want to select duplicate records only in database

Can u pls help

 

[kapoor]

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