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 secondary keys?
What does the argument [or replace] do?
what is oracle database ? : Sql dba
column A column b | output 10 7 | 10 5 8 | 8 7 -9 | 7 3 5 | 5 0 6 | 6 Write a sql query to print such output.
What is a sql select statement?
Why trigger is used in sql?
Explain what is sql?
How can you select unique records from a table?
Which tcp/ip port does sql server run on? How can it be changed? : Sql dba
How is data stored on a disk?
How do I run sql?
What is on delete set null?
How delete a row in sql?
How to run sql*plus commands in sql developer?
How is pl sql different from sql?