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 the difference between a local and a global temporary table? : Sql dba
Which join is like an inner join?
what is the syntax for using sql_variant_property? : Transact sql
Is sql procedural language?
How do I run a pl sql program?
What is auto increment feature in sql?
What is the current version of sql?
What is nested table in pl sql?
What does desc stand for?
How do you remove duplicate records from a table?
What are properties of the transaction?
Which one is better subquery or joins?
What are the events on which a database trigger can be based?
how would you enter characters as hex numbers? : Sql dba
how to calculate expressions with sql statements? : Sql dba
