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 is linked report?

131

Tell me the phases a transaction has to undergo?

962

In which tcp/ip port does sql server run? Can it be changed?

991

What is GUID in sql server?

1165

Define Wed Edition in SQL Azure?

100

What is the server name for sql management studio?

1024

How to execute a sql statement using odbc_exec()?

1144

how to trace the traffic hitting a sql server? : Sql server database administration

1879

What is the architecture of ms sql reporting service?

985

Define normalisation?

1118

Explain about analysis services?

1051

How to enable tcp/ip protocol on a sql server?

1161

What is the difference between Triggers and Stored Procedure?

1097

Characterize join and name diverse sorts of joins?

968

What is the name of the system variable that returns the number of rows affected by a SQL statement?

1015