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
- 6014 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 |
Hi can anyone tell me where are the dumps found of OCA certification.. Also the materials to be studied for the preparation.
what is normalisation?what are its uses?
HOW TO CONVERT ORACLE TABLE DATA (RECORDS)INTO EXCEL SHEEET?
How do I decide when to use right joins/left joins or inner joins or how to determine which table is on which side?
primary key is foreign key for the same table?
What is an external table?
State the various uses of dbcc command?
How to define default values for formal parameters?
What are the different type of Segments ?
Explain the family trees and connection by clause
How to get execution path reports on query statements?
create one table to capture an employee details with a primary key.
Oracle General 
