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.
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.
Talk To Other Members
RE: selecting 1 instance of duplicate records
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
Can u pls help
RE: selecting 1 instance of duplicate records
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