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 authentication modes does sql server support? : Sql server database administration

1119

---

How do we Backup SQL Azure Data?

108

---

What gets stored inside msdb database?

1255

---

SQL Server Architecture ?

2462

---

What are examples of triggers?

1088

---

What are alternate keys?

984

---

Write an sql query to sort a table according to the amounts in a row and find the second largest amount.

932

---

Does a full backup include transaction log?

981

---

What is the contrast amongst drop and truncate?

1034

---

Do you know what is a trace frag? Where do we use it?

1004

---

Explain the architecture of ms sql reporting service?

926

---

What are the extra roles available in msdb? : sql server security

1138

---

What are the different editions available in sql server 2000?

1056

---

How to create a view with data from multiple tables?

1017

---

How to create new table with "create table" statements?

1113

---