Interested to Buy Any Domain ? << Click Here >> for more details...
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.
- 2 Answers
- 5917 Views
- Microsoft, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / nithin
Hi
I could possibly think of only one solution without using
group by clause.
create table emp_bkp as select distinct * from employee
drop table employee
rename emp_bkp to employee
Let me know if there is any other possible answer
| Is This Answer Correct ? | 3 Yes | 1 No |
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 |
What are the different types of synonyms?
What WHERE CURRENT OF clause does in a cursor?
How to see free space of each tablespace?
What is Undo Management Advisor in Oracle?
what is the difference between substr and instr function in oracle?
How to find no of saturdays in a month using single sql ?
How to use regular expression in pattern match conditions in oracle?
what is the difference between table and veiw?
How is it different from a normal table?
In AP we done Customizations for Late Payments Charges. For Reporting Purpose What are the Documents Prepared for Customer Understanding??
Design database draw er diagram for a certain scenario ?
0 Answers Keane India Ltd, TATA,
How to assign a tablespace to a users in oracle?
Oracle General 
