Answer Posted / tallapaneni

create table emp(eid int, ename varchar(50),age int)

insert into emp values( 1,'ramu1,21)
insert into emp values( 1,'ramu2,22)
insert into emp values( 2,'ramu3,22)
insert into emp values( 3,'ramu4,24)
insert into emp values( 4,'ramu5,25)
insert into emp values( 5,'ramu6,26)
insert into emp values( 2,'ramu7,27)
insert into emp values( 6,'ramu8,28)
insert into emp values( 6,'ramu9,29)

SELECT * FROM emp

WITH aaa AS (SELECT (ROW_NUMBER() OVER (PARTITION BY eid
ORDER BY eid)) AS RNum FROM emp)
DELETE FROM aaa WHERE RNum IN (SELECT a.RNum FROM aaa AS a,
aaa AS b WHERE a.RNum > b.RNum GROUP BY a.RNum)

SELECT * FROM emp order by eid



Regards,
Raaam

How to get all stored procedures in sql server?

1059

---

Is sql server difficult to learn?

968

---

How to link tables in sql server?

974

---

Is natural join and equi join same?

1030

---

How do I find the default sql server instance?

990

---

What do you mean by sql server 2005 express management tools?

1353

---

How to apply cascading referential integrity in place of triggers?

1090

---

Why SQL Agent is used?

1204

---

Tell me the phases a transaction has to undergo?

1019

---

What is the concept of optimization?

1110

---

Explain rdbms?

1076

---

What happens if you insert a duplicate key for the primary key column in ms sql server?

1023

---

What are different types of table joins?

1052

---

What are rest-style architecture's?

172

---

What is primary key, unique key, and foreign key?

1015

---