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

How can you control the amount of free space in your index pages?

1010

How can sql server instances be hidden? : sql server security

1053

Do you know what are different types of replication in sql server?

1036

What are the five characteristics of good data?

869

What do you understand by hotfixes and patches in sql server?

914

Can we call future method from trigger?

879

What is difference between standardization and normalization?

1019

How we can refresh the view?

1056

How to create indexed view?

986

Why use “pivot” in sql server?

1042

How do you migrate data from mssql server to azure?

165

Explain the properties of sub-query in sql server?

954

How to create new tables with "create table" statements in ms sql server?

998

How can you append an identity column to a temporary table?

875

List the advantages of using stored procedures?

997