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

What is right outer join in sql server joins?

1118

---

Explain what is public role in sql server?

1055

---

How to create function without parameter in sql server?

990

---

How to execute multiple stored procedures at one time in sql server?

941

---

What is the use of group by clause?

899

---

Create a dts package to produce a text file using the ‘update statistics’ command for the tables in a database with obsolete statistics.

968

---

what does the automatic recovery do? : Sql server administration

958

---

Which operator do you use to return all of the rows from one query except rows are returned in a second query?

941

---

How to sort the query output with order by clauses in ms sql server?

982

---

Explain the phases a transaction has to undergo?

985

---

What is conditional split?

986

---

What are the risks of storing a hibernate-managed object in a cache? How do you overcome the problems?

1024

---

What do you understand by user-defined function in the sql server?

900

---

What is the difference between ddl,dml and dcl commands?

1056

---

How to use go command in "sqlcmd"?

1125

---