SELECT COUNT(CoumnName) AS Expr1 FROM Tablename GROUP BY Coum

how to find out the repeated value from table using groupby
function?

Question Posted / arshi

Answer Posted / arshi

SELECT COUNT(CoumnName) AS Expr1
FROM Tablename
GROUP BY CoumnName
HAVING (COUNT(CoumnName) > 1)

Is This Answer Correct ?

8 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What are wait types?

1010

Explain system views?

1020

How can we delete a table in sql server?

921

What is sql server english query?

1034

What is mean by dml?

943

What is outer join in sql server joins?

1044

What are the database objects? : SQL Server Architecture

980

What is the difference between functions and scalar functions?

1122

What is an inner join?

909

When should you use an instead of trigger?

916

How self join is different from outer join?

1060

Describe in brief authentication modes in sql server.

962

What are the hotfixes and patches in sql server?

972

What are the steps you can take to avoid “deadlocks”?

918

What stored by the master?

901