Interested to Buy Any Domain ? << Click Here >> for more details...
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 is trigger in sql and its types?
What are dml commands?
How does one load ebcdic data? : aql loader
what is 'mysqladmin' in mysql? : Sql dba
What is sql constant?
How sql query is executed?
What is an exception in pl/sql?
What is the importance of sqlcode and sqlerrm?
What is cursor explain with example?
How to read/write files from pl/sql?
How to add new employee details in an employee_details table with the following details
What version is sql?
What programs use sql?
What is the difference between cluster and non-cluster index?
What are all the ddl commands?
