Interested to Buy Any Domain ? << Click Here >> for more details...
write sub query for eliminating duplicate rows using
analytical function?
- 3 Answers
- 12938 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 the use of & in pl sql?
What is the maximum number of rows in sql table?
How to execute a stored procedure?
Is oracle and sql same?
How do we use distinct statement? What is its use?
Is pl sql different from sql?
What is the sql case statement?
Why do we need pl sql?
What is normalization in a database?
Why stored procedures are faster than query?
How do I view output in sql developer?
What is trigger in sql and its types?
What is cursor status?
What is right join in sql?
What are all the different normalization?
