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 primary key and unique key?
how to use regular expression in pattern match conditions? : Sql dba
How many subqueries can be nested in a statement?
what is the syntax used for partition in tsql? : Transact sql
What are schema-level triggers?
What is a heap in sql?
What is difference between db2 and sql?
what is the difference between blob and text? : Sql dba
explain the advantages and disadvantages of stored procedure? : Sql dba
What is the difference between rollback and rollback to statements?
What is a unique key and primary key and foreign key?
Explain commit, rollback and savepoint.
When do we use triggers?
what is the difference between char_length and length? : Sql dba
What is procedure explain with example?
