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

What are the types of joins in sql?

0 Answers  

---

What is t-sql script to take database offline – take database online.

0 Answers  

---

What are the types of model in sql server and explain

2 Answers   TCS,

---

What is database dimension? : sql server analysis services, ssas

0 Answers  

---

What are subquery and its properties?

0 Answers  

---

please can anyone answer this query Table 1 has 2 columns: EmployeeId,Age Table 2 has 2 columns: EmployeeId, Region Write SQL to Find the region who has the oldest person

10 Answers  

---

What are different replication agents and what's their purpose? : sql server replication

0 Answers  

---

You are doing log shipping due to some reasons it is failing. How you will proceed from there

0 Answers  

---

Let us say master db itself has no backup. Now you have to rebuild the db so what kind of action do you take?

1 Answers  

---

What is the difference between Triggers and Stored Procedure?

0 Answers   HCL,

---

Explain about system database?

0 Answers  

---

What is the difference between for trigger and after trigger?

0 Answers  

---