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
- 19795 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
What is dbo in sql?
What is cartesian join in sql?
What is difference between stored function and application function?
What is set serveroutput on in pl sql?
What is sql character function?
What is view? Can we update view
How many clustered indexes can be created on a table?
What is column?
how many sql ddl commands are supported by 'mysql'? : Sql dba
What has stored procedures in sql?
what is offset-fetch filter in tsql? : Transact sql
Can dml statements be used in pl/sql?
When a dml statement is executed, in which cursor attributes, the outcome of the statement is saved?
How to check if a column is nullable before setting to nullable?
what is recursive stored procedure? : Sql dba
