Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / karthik
with [dup_cte] as {
select row_number(partition by eid order by eid) as rn from emp}
go
delete from [dup_cte] where rn>1
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What are the three pl sql block types?
What is secondary key?
What is an ndf file?
What is rank () in sql?
what are the differences between char and nchar? : Sql dba
What is the purpose of my sql?
What do we need to check in database testing?
What is a primary key? Explain
what is recursive stored procedure? : Sql dba
What is difference between inner join and cross join?
which types of join is used in sql widely? : Sql dba
Explain the difference between cursor declared in procedures and cursors declared in the package specification?
Is clustered index a primary key?
Is pl sql a scripting language?
what are the advantages of sql ? : Sql dba
