Answer Posted / shankar

First Of All Create Table
create table EMP(empid int, ename varchar(10),sal int,
deptid int)

insert into EMP values(11, 'Ram', 10000, 10)
insert into EMP values(11, 'Ram',10000,10)
insert into EMP values(22, 'Raj', 20000, 20)
insert into EMP values(22, 'Raj', 20000, 20)
insert into EMP values(33, 'Anil', 15000, 30)
insert into EMP values(33, 'Anil', 15000, 30)
insert into EMP values(44,'bbb',11111,40)
--Now Run This query It works
Declare @empID int, @RecCount int,@Name varchar (10),@Sal
int, @deptid int
SET @RecCount = 0
Declare MyCur Cursor for
Select empid,ename Sal,DeptID,Count(ID)-1 as Records from
EMP Group BY empid,ename Sal,DeptID having Count(empid)>1
Open MyCur
Fetch FROM MyCur INTO @empID,@Name,@sal,@DeptID,@RecCount

WHILE @@FETCH_STATUS = 0
BEGIN
SET ROWCOUNT @RecCount

DELETE from EMP where empID= @empID
SET @empID= 0
SET @Name = ''
SET @Sal= 0
SET @DeptID = 0
SET @RecCount = 0
SET ROWCOUNT 0
Fetch FROM MyCur INTO @empID,@Name,@sal,@DeptID,@RecCount
END

Close MyCur
DEallocate MyCur

What the different topologies in which replication can be configured?

1149

---

What do you understand by triggers?

981

---

What are the system database in sql server 2008?

1101

---

Name few of the dcl commands in sql?

1057

---

What is difference between group by and having?

998

---

How to rename an existing column with the "sp_rename" stored procedure in ms sql server?

1156

---

How do I find my localdb version?

1034

---

What do you mean by an execution plan? How would you view it?

972

---

What happens if you are trying to access a schema not owned by you?

1023

---

what is a schema in sql server 2005? : Sql server database administration

1086

---

What is multilevel indexing?

982

---

what is the difference in login security modes between v6.5 and 7.0? : Sql server database administration

1175

---

What is ddl and dml commands?

961

---

How to return the second 5 rows in ms sql server?

1110

---

What is a sql join?

1084

---