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
- 5472 Views
- Microsoft, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
Explain temporal data types in oracle
What is analyze command used for?
What is sharded cluster?
How do I learn what codesets are available in oracle?
In XIR2 if we lost the administration password .How can we regain the password?thanks in advance.
What is a data dictionary and how can it be created?
how to code performance tuning of oracle PL/SQL? can any body send me the perfect answer?
How to set a transaction to be read only in oracle?
What is materialized view in Oracle?
What is rowid and rownum in oracle?
What is dynamic proxy?
How to add a new column to an existing table with a default value?
How do I recompile a procedure in oracle?
What is background process in Oracle?
What is java oracle used for?
