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
- 5899 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 do I spool in oracle?
Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).
Differentiate between function and procedure in oracle.
Difference between the “verify” and “feedback” command?
Briefly explain what is literal? Give an example where it can be used?
How to join two tables in a single query using oracle?
What is analyze command used for?
How to specify default values in insert statement using oracle?
How to assign a table row to a record variable?
What happens to the data files if a tablespace is dropped?
Explain what are the advantages of views?
What is meant by raw datatype?
How do we get field detail of a table?
Is java required for oracle client?
How will you identify oracle database software release?
