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 is 'mysqlshow'? : Sql dba
Is pl sql a programming language?
How to rename a column in the output of sql query?
I need to write a simple query,which one is better select statement or stored procedure?and why?
How do you concatenate in sql?
What is the difference between nested table and varray?
What are string functions in sql?
display null value rows with out using null function?
What is time based sql injection?
What is difference between procedure and trigger?
What is trigger in sql and its types?
What is the cause of mutating table error and how can we solve it?