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

Give an example of SQL injection attack ?

991

What is raid? : SQL Server Architecture

1151

What does top operator do?

1000

Do you know what is similarity and difference between truncate and delete in sql?

992

List down some advantages of sql stored procedure?

945

What are scheduled tasks in sql server?

1060

How do you set a trace flag in sql server?

1023

How many types of relations are there between dimension and measure group? : sql server analysis services, ssas

1181

How to change the name of a database user?

945

What is serializable?

1026

How to scale out a federation by Sql statement?

116

How to how to convert numeric expression data types using the convert() function??

1032

What is partition in sql server?

1021

Write an sql query to find first weekday of the month?

899

What are the differences between INNER JOIN, LEFT JOIN and RIGHT JOIN in SQL Server?

1112