write sub query for eliminating duplicate rows using
analytical function?
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
Can we use pl sql in sql server?
What is the difference between rename and alias?
Can we create table inside stored procedure?
What is consistency?
What are the basic sql commands?
Is hadoop a nosql?
What is the difference between cluster and non-cluster index?
explain about mysql and its features. : Sql dba
What is the use of partition by in sql?
Explain ddl statements in pl/sql?
What are functions in sql?
Does truncate require commit?
How can you fetch first 5 characters of the string?
How is pl sql different from sql?
What is sql table?