Answer Posted / mohan

create table #temp(empid int, ename varchar(10),sal int,
deptid int)

insert into #temp values(11, 'Ram', 10000, 10)
insert into #temp values(11, 'Ram',10000,10)
insert into #temp values(22, 'Raj', 20000, 20)
insert into #temp values(22, 'Raj', 20000, 20)
insert into #temp values(33, 'Anil', 15000, 30)
insert into #temp values(33, 'Anil', 15000, 30)
insert into #temp values(44,'bbb',11111,40)

select * from #temp

set rowcount 1
delete from #temp where empid in(select empid from #temp
group by empid having count(*)>1)
while @@rowcount>0
begin

delete from #temp where empid in(select empid from #temp
group by empid having count(*)>1)
end
set rowcount 0

select * from #temp

what are the steps you will take, if you are tasked with securing an sql server? : Sql server database administration

959

---

What is a DBMS, query, SQL?

998

---

what's sql server? : Sql server database administration

932

---

How to rebuild indexes with alter index ... Rebuild?

1036

---

What is standby servers? Explain types of standby servers.

935

---

What is meant by referential integrity?

959

---

What the different types of Replication and why are they used?

981

---

Which joins are sql server default?

939

---

Define Business Edition in SQL Azure?

100

---

What is the difference between executequery () and executeupdate ()?

969

---

what do you understand by change data capture?

941

---

Explain sql server service broker?

929

---

How do I edit a procedure in sql server?

902

---

Difference between report and query parameter. Why do we need different type of parameter?

906

---

What is user-defined functions? What are the types of user-defined functions that can be created?

981

---