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

Why we use trigger in sql server with example?

919

What is a cursor, index in sql?

1016

How do I find the sql server instance name?

922

Tell me what do you understand by a view? What does the with check option clause for a view do?

956

Explain the microsoft sql server delete command? : SQL Server Architecture

1011

Why use stored procedures in sql server?

958

What is PROJECTION Operation?

962

Find first and last day of current month in sql server

979

How to retrieve error messages using mssql_get_last_message()?

994

What is Federation and Federation Member?

Describe in brief system database.

951

Which joins are sql server default?

939

What is always encrypted?

942

Do you know what is normalization of database? What are its benefits?

1029

What is scd (slowly changing dimension)? : sql server analysis services, ssas

954