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
- 19760 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
How do you write an index?
What are the two characteristics of a primary key?
what is single byte over head in oracle..?
Explain how you can copy a file to file content and file to pl/sql table in advance pl/sql?
What is sql*loader?
How do I count records in sql?
What can I use instead of union in sql?
How can you view the errors encountered in a trigger?
What are the different operators available in sql?
explain the advantages and disadvantages of stored procedure? : Sql dba
Is big data nosql?
what is denormalization. : Sql dba
Explain alias in sql?
What is pl/sql language case sensitive?
What is bulk compiling in pl/sql.?
