Answer Posted / sonia

Create table info(comp_id int identity(101,1),comp_name
varchar(50))
insert into info values('Progressive Ltd.')
insert into info values('Progressive Ltd.')
insert into info values('EliResearch')
insert into info values('Patni')
insert into info values('Accenture')
insert into info values('Accenture')
select * from info

DELETE FROM info
WHERE comp_name IN
(SELECT comp_name FROM info
GROUP BY comp_name HAVING COUNT(comp_name) > 1)

What is difference between group by and having?

944

---

What is database black box testing?

1037

---

How do you use a subquery to find records that exist in one table and do not exist in another?

1051

---

What is a constant or literal in ms sql server?

1049

---

How will you make an attribute not process? : sql server analysis services, ssas

1094

---

List the different types of collation sensitivities in sql server?

1047

---

What are the differences between ms sql server & oracle?

1066

---

How to delete an existing database user?

1021

---

What is the difference between deallocate cursor and close cursor?

1263

---

What is de-normalization and what are some of the examples of it?

976

---

What is user-defined function?

981

---

What is multilevel indexing?

930

---

How many types of the database links?

1071

---

What do you mean by cardinality?

903

---

What is the difference between a function and a trigger?

1087

---