Interested to Buy Any Domain ? << Click Here >> for more details...
one of the column in my table contains the data like
SAL
----
1000
1000
2000
3000
3000
So my requirement is i want output like
SAL
---
1000
2000
3000
it mean i want to delete duplicate rows only how should u
write query?
- 9 Answers
- 11353 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / swastik
DELETE FROM Emp A
WHERE ROWID NOT IN
(
SELECT MIN(ROWID)
FROM Emp B
WHERE A.Sal = B.Sal
)
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is Materialized View? In What Scenario we Use Materialized View?
How to read xml file in oracle pl sql?
What is use of term?
How can you load multi line records? : aql loader
What are the operators used in select statements?
What is %s in sql?
Describe different types of general function used in sql?
What are schema-level triggers?
What does closing a cursor do?
How to rename a column in the output of sql query?
What is the basic structure of an sql?
Which is better join or inner query?
Can we call procedure in select statement?
Which operator is used in query for pattern matching?
How can you get sql*loader to commit only at the end of the load file? : aql loader
