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
- 6008 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
What is an oracle function?
How to assign values to variables?
How to execute a stored procedure in oracle?
What privilege is needed for a user to connect to oracle server?
How to calculate date and time differences in oracle?
Why should I use oracle database?
How to define an external table with a text file?
How to convert a date to char in oracle? Give one example.
What are internal user account in oracle?
how do u setup a replication site?
What is bind variable in oracle 11g?
How to loop through data rows in the implicit cursor?
What are the limitations oracle database 10g xe?
What is execute immediate in oracle?
How to use windows user to connect to the server?
