There is a big table with "n" of rows and 40 + columns .It
doesn't have primary key.How do you select the primary key.
In other words how do you get the duplicate records.
Answer Posted / harikanth
Suppose Table name is Dup_Del with id as a column(consists
10,20,30,10,10,30,20)then
select * from Dup_Del
where rowid not in(select * from
(select min(rowid) from Dup_Del
group by id
);
the above query will give you the duplicate records. if you
want unique records then
select * from Dup_Del
where rowid in(select * from
(select min(rowid) from Dup_Del
group by id
);
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
hey friends, What are the steps I can do to transfer the database from Microsoft Access 2003 to oracle10g (or SQL) Best regards
What is background process in Oracle?
How to connect to a local oracle 10g xe server?
Can objects of the same schema reside in different tablespace?
Which dictionary tables and/or views would you look at to diagnose a locking issue?
What is a initialization parameter file in oracle?
How to load a large xml file?
How to delete all rows a table in oracle?
What are the limitations oracle database 10g xe?
How to export data with a field delimiter?
What are named parameters?
What is a nested table?
How do I manually create a database in oracle?
What is the dynamic sql in oracle?
What are the data types in oracle?