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
- 21679 Views
- Cap Gemini, TCS, I also Faced
- E-Mail Answers
Answer Posted / amit
SQL>DELETE FROM <TABLE NAME>
WHERE ROWID NOT IN (SELECT MIN(ROWID) FROM <TABLE NAME>
GROUP BY SAL);
| Is This Answer Correct ? | 9 Yes | 3 No |
Post New Answer View All Answers
what is a composite key ? : Sql dba
when is the use of update_statistics command? : Sql dba
What is the difference between rollback and rollback to statements?
What is the use of sqldataadapter?
what are the differences between char and nchar? : Sql dba
Why do we need cursors in pl sql?
How can get second highest salary in sql?
What information is needed to connect sql*plus an oracle server?
how to run 'mysql' commands from a batch file? : Sql dba
Are ddl triggers fired for ddl statements within a pl/sql code executed using the dbms.sql package?
What is the basic form of sql query?
What does the base_object_type column shows in the user.triggers data dictionary view?
What are the syntax and use of the coalesce function?
What is primary key and unique key?
How to prepare for oracle pl sql certification?
