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

Does index slows down insert statements?

0 Answers  

---

How to edit table in sql server 2017?

0 Answers  

---

What are the advantages to use stored procedures?

0 Answers   Ernst Young,

---

After creating the cube, if we added a new column to the oltp table then how you add this new attribute to the cube? : sql server analysis services, ssas

0 Answers  

---

i want to join two queries....and i want to run them as one after another that is want output of first query then second , then again output of first query then second and so on...

2 Answers  

---

When would you use sql joins?

0 Answers  

---

How to convert a numeric expression from one data type to another?

0 Answers  

---

Does group by or order by come first?

0 Answers  

---

What are the operating modes in which database mirroring runs?

0 Answers  

---

How do you read transaction logs

1 Answers  

---

I have student marks in a student table. I need second highest mark .Then what will the query for this?

37 Answers   NetCore, Patni, SAP Labs, Temenos, Wipro,

---

1.Describe way(s) to tune the SQL table in order to optimize performance. 2. Explain SQL Injection and how can you prevent them?

1 Answers   Techno Solutions,

---