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
- 5969 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
how may join possible between (requisition with purchase order)
Explain the use of indexes option in imp command.
Give the constructs of a package, function or a procedure.
What are the extensions used by oracle reports?
Does oracle database need java?
What are the original export and import utilities?
Can you tell me how to add new column in existing views?how?How is possible?
Why use resource manager in Oracle?
What is the maximum limit on the number of columns in a table?
What is a snapshot log?
Explain compound trigger in oracle?
In what script is snap$ created? In what script is the scott/tiger schema created?
Explain oracle instance.
What is a trace file and how is it created in oracle?
Explain the use of consistent option in exp command.
