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 in the table
permanently and i want output in the above formatow should u
write query?
- 13 Answers
- 21697 Views
- Cap Gemini, TCS, I also Faced
- E-Mail Answers
Answer Posted / bibhudatta panda
DELETE FROM TABLENAME
WHERE ROWID NOT IN(
SELECT MAX(ROWID)
FROM TABLENAME
GROUP BY Sal
)
| Is This Answer Correct ? | 4 Yes | 1 No |
Post New Answer View All Answers
Define union, minus, union all, intersect ?
Is sql procedural language?
Define a temp table?
How do you use a while loop in pl sql?
What are different types of keys?
What is a schema sql?
What is the difference between join and natural join?
what is the difference between where clause and having clause? : Sql dba
what is unique key constraint? : Sql dba
what is a constraint? : Sql dba
Is a table valued function object?
what is a record in a database ? : Sql dba
What is blind sql injection?
What is a loop in sql?
Explain 3 basic parts of a trigger.
