Interested to Buy Any Domain ? << Click Here >> for more details...
write a query to delete similar records in particular
fields(columns) in different tables
- 6 Answers
- 13932 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / satyam kumar
Hi,
I have manipulated Khandu Shinde answer because it will
delete complete row.
delete from emp where rowid not in ( select max(rowid) from
emp group by empno having count(redundantcolumnName) > 1)
Note: work only with Oracle.
| Is This Answer Correct ? | 1 Yes | 5 No |
Post New Answer View All Answers
Enlist the characteristics of pl/sql?
what is a scheduled jobs or what is a scheduled tasks? : Sql dba
When do we use triggers?
How to write a single statement that concatenates the words ?hello? And ?world? And assign it in a variable named greeting?
What is write ahead logging in sql server?
List the different type of joins?
Do stored procedures prevent sql injection?
What do you mean by field in sql?
Can we join same table in sql?
Is sql difficult?
Mention what is the function that is used to transfer a pl/sql table log to a database table?
how tsql statements can be written and submitted to the database engine? : Transact sql
What are sql*plus environment variables?
What is user defined functions?
Can unique keys be null?
