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.
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 to convert csv to table in oracle?
What is data file?
Explain self joins in oracle?
What is transport network substrate (tns) in oracle?
How to execute a stored procedure in oracle?
What is a table index in oracle?
What is difference between truncate and delete?
What are the extensions used by oracle reports?
How do we get field detail of a table?
Please explain drop constraint oracle?
How to resolve name conflicts between variables and columns?
What are the four Oracle system processes that must always be up and running for the database to be useable?
What is the difference between a primary key & a unique key?
What is the difference between pre-select and pre-query?
How to connect to a remote server?