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
- 6112 Views
- Microsoft, I also Faced
- E-Mail Answers
Answer Posted / harikanth
Suppose Table name is Dup_Del with id as a column(consists
10,20,30,10,10,30,20)then
select * from Dup_Del
where rowid not in(select * from
(select min(rowid) from Dup_Del
group by id
);
the above query will give you the duplicate records. if you
want unique records then
select * from Dup_Del
where rowid in(select * from
(select min(rowid) from Dup_Del
group by id
);
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Difference between varchar and varchar2 data types?
How do I manually uninstall oracle client?
What is archive log in Oracle?
How to assign values to data fields in record variables?
What is a schema in oracle?
In SAP ECC 6.0 , under DB02 tcode , Tablespace name to be explain stepy step all the col
What is blob data type in oracle?
What are the numeric comparison operations?
How to invoke the original export import utilities?
Explain oracle instance.
How do I manually create a database in oracle?
How to generate query output in html format?
How do you bind variables in oracle?
How to define a data field as not null?
What the is the diff between local index and global index. give some example.
