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
- 6114 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 open database communication (odbc) in oracle?
How to delete a column in an existing table in oracle?
Give the various rollback segment states.
What is the effect of setting the value "all_rows" for optimizer_goal parameter of the alter session command? What are the factors that affect optimizer in choosing an optimization approach?
What are joins, explain all types of joins?
What does sharding mean?
How do I connect to oracle database?
How to write text literals in oracle?
What is an oracle database table?
How we can able to import our own template (users designed MS-Word templates) which has many tabular columns; need to pass some values generate by Oracle-reports9i? Actually need to import more than 400 MS-Word templates into Oracle Reports-9i to minimize layout design in Reports.
What is blob datatype?
How to delete a column in an existing table?
How to assign a table row to a record variable?
What are advantages of dateset in datastage?
How to assign data of the deleted row to variables?
