write sub query for eliminating duplicate rows using
analytical function?
Answers were Sorted based on User's Feedback
Answer / korimantu
delete from table name where rowid not in(select max(rowid)
from group by last_name);
or
delete from table name where rowid>(select min(rowid) from
where a.last_name=b.last_name);
Is This Answer Correct ? | 4 Yes | 2 No |
Answer / 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 |
What are the advantages of indexing?
What is normalization in sql?
What does the sign mean in sql?
What is the difference between having and a where in sql?
What is Difference Between delete and Truncate?
What is the use of sqlerrd 3?
Is record in oracle pl sql?
What is pl/sql table? Why it is used?
How to run sql commands in sql*plus?
How many null values can be inserted in a coulmn whihc is unique constraint
What are the sql aggregate functions?
What is the location of pre_defined_functions.