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
- 6113 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 |
5. Display full details for the creditor/s who has received the single largest payment. Do not use a table join or set operator anywhere in your query.
what is null value?
How index is implemented in oracle database?
What is the minimum client footprint required to connect c# to an oracle database?
What is Hash Cluster ?
How to create additional tablespaces for an new database?
what is the output of select * from emp where null=null & select * from emp where 1=1
Do View contain Data ?
What is the difference between SQL, DDL, and DML?
7 Answers BeBo Technologies, Wipro,
How would you optimize a slow SQL query?
what is Table ?
Define Transaction ?
Oracle General 
