Interested to Buy Any Domain ? << Click Here >> for more details...
how to eliminate duplictes in column except group and
section?
- 2 Answers
- 6950 Views
- iFlex, TCS, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / sandeep
the above answer will work ifonly one dplicate row is there,
if there are more than one duplication.
then
delete from table_name where rowid not in(select min(rowid)
from table_name group by column_name having count(*)>1)
| Is This Answer Correct ? | 6 Yes | 0 No |
Answer / jagan
delete from tablename a where rowid not in(select max(rowid)
from tablename b where a.rowid=b.rowid)
| Is This Answer Correct ? | 5 Yes | 3 No |
I need a query to list out "Subinventory Transfer" record from Oct 2016 to Oct 2017 for few users
What is the difference between flex mode and confined mode?
what exactly u write in when_new_form_instance
What is the difference between a Function Key Trigger and Key Function Trigger ?
How can a cross product be created?
What built-in is used for showing the alert during run-time?
Where is a procedure return in an external pl/sql library executed at the client or at the server?
What are the two ways to incorporate images into a oracle forms application?
What are the vbx controls?
Explain how one can iterate through items and records in a specified block?
What is an oracle report?
What is an Lov?
Oracle General 
