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
Please Help Members By Posting Answers For Below Questions
What is union?
What is the use of & in pl sql?
Which normal form is best?
Can we use ddl commands in pl sql?
Why indexing is needed?
Which sorts rows in sql?
What are packages in pl sql and also explain its advantages?
Why stored procedure is faster than query?
What is mdf ldf and ndf?
what is a materialized view? : Sql dba
What is sql integrity?
Why do we need view in sql?
How do I make my sql query run faster?
How do I create a sql database?
What are the three forms of normalization?
