SELECT COUNT(Column_Name) FROM Table_Name WHERE (Condition) GROUP BY Colu

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

Question Posted / navin.cp

Answer Posted / navin.cp

SELECT COUNT(Column_Name) FROM Table_Name WHERE (Condition)
GROUP BY Column_Name

Is This Answer Correct ?

0 Yes

3 No

Please Help Members By Posting Answers For Below Questions

What is a cube? : sql server analysis services, ssas

1055

What are data regions?

140

How does recursive cte works in sql server?

1059

What are the mathematical functions supported by sql server 2005?

1127

What are different types of statements that are supported by sql?

1101

How to create hyperlink from returned sql query ?

1183

How do I create an extended event in sql server?

1005

Name three of the features managed by the surface area configuration tool? : sql server security

1034

Explain alternate key, candidate key and composite key in sql server?

953

Write a query for primary key constraint with identity key word?

1084

Define union, union all, minus, intersect?

1035

can a database be shrunk to 0 bytes, if not, why? : Sql server administration

1313

What is single-user mode and what are the steps you should follow to start sql server in single-user mode?

1025

What is the sql case statement used for?

1133

Explain active/passive and active/active cluster configurations?

1109