Answer / mr.abdul rahim

select count(column), column from table group by column
having count(column) > 1

Answer / pavan

Hi,
try this query.In this query sal one val is duplicated
4items


select sal,count(sal) from test group by sal having count
(*)>1

Answer / lalit goyal

select count(*) from (select boss_ID,COUNT(boss_ID) as s from dbo.Employee group by boss_ID ) a where s>1

Can you explain what is indexed view? How to create it?

0 Answers  

---

What is data source object?

0 Answers  

---

What is a self join in sql server?

0 Answers  

---

When I delete any data from a table, does the sql server reduce the size of that table?

0 Answers  

---

What is the difference between DataRow.Delete() and DataRow.Remove()?

0 Answers  

---

What are the characteristics of modern DBMS?

0 Answers   Ericsson,

---

You want to check the syntax of a complicated update sql statement without executing it. What command should you use?

0 Answers  

---

Questions regarding Raiseerror?

1 Answers  

---

How to get a list of table columns using the "sp_columns" stored procedure in ms sql server?

0 Answers  

---

i use few third party softwares. they r all having their own databases . but the data is repeated in all these databases - say a person is in all the three databases, but his name is stoared in diff format in all databases i want to create a centralised database ,and i dont want to re-enter the records . using the exisating records how can i build a centralised database?

1 Answers   Fidelity,

---

Tell me what is the difference between locking and multi-versioning?

0 Answers  

---

What are the different index configurations a table can have?

0 Answers  

---