Interested to Buy Any Domain ? << Click Here >> for more details...
write sub query for eliminating duplicate rows using
analytical function?
- 3 Answers
- 12997 Views
- Metric Stream, I also Faced
- E-Mail Answers
Answer Posted / vyshak
delete from table where rowid not in (select max(rowid) from
table group by all column names);
or
delete (dense_rank() over(partition by all column names))dn
from table where dn>2;
| Is This Answer Correct ? | 4 Yes | 3 No |
Post New Answer View All Answers
What is clause in sql?
what is primary key? : Sql dba
Explain the significance of the & and && operators in pl sql.
What is compute?
Which constraints we can use while creating database in sql?
how to see the create table statement of an existing table? : Sql dba
what is the difference between $message and $$message? : Sql dba
What is anonymous block in sql?
What is a system versioned table?
what is the difference between undefined value and null value? : Sql dba
What is nested table in pl sql?
What is pragma in pl sql?
What are transaction and its controls?
Define concurrency control. : Transact sql
What is normalisation in sql?
