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
How does Oracle guarantee data integrity of data changes?
Write a syntax for update query in oracle?
how to code performance tuning of oracle PL/SQL? can any body send me the perfect answer?
Give the advantages and disadvantages of clusters.
How to use windows user to connect to the server?
What happens to the data files if a tablespace is dropped?
How to convert times to characters in oracle?
How different is ms access and oracle?
How to display employee records who gets more salary than the average salary in the department?
What are dml statements in oracle?
What would you do with an in-doubt distributed transaction?
What is blob datatype?
What privilege is needed for a user to create views in oracle?
nw i'm doing MBA system and planning to do oracle,database management.tell me that whether it is useful r not?.refer any course for my carrier pls
What is materialized view in Oracle?