Answer Posted / vamsi
for example our emp table have duplicate rows than we can
run this query to delete those duplicate rows
Delete from emp a
where rowid <> ( select max(rowid) from emp where empno =
a.empno);
| Is This Answer Correct ? | 13 Yes | 4 No |
Post New Answer View All Answers
What version is sql?
What does varchar include?
What is the difference between delete and truncate statement in sql?
What is trigger in sql?
How can I see all tables in sql?
give the syntax of grant and revoke commands? : Sql dba
how to increment dates by 1 in mysql? : Sql dba
How can you load multi line records? : aql loader
What is using in sql?
How is indexing done in search engines?
How do you drop a trigger?
What is nvarchar max in sql?
What are the different types of tables in sql?
How do I quit sql?
What is the process of debugging?
