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 are the dmvs? : sql server database administration

1045

How do I completely remove sql server instance?

1089

Explain what are the restrictions that views have to follow? : SQL Server Architecture

1041

What is the recursive stored procedure in sql server?

1015

Explain database normalization?

1210

What are the 2 types of classifications of constraints in the sql server?

1112

What are different types of data sources?

1006

Write a sql query to display the current date?

1085

What is change data capture (cdc) feature?

1050

How do you implement session management in SQL Server mode?

1087

hi i am working as a testengineer , so i want to no the backend data base connection can any one tell mwe in detail

2209

Is mysql the same as sql server?

969

How to list all objects in a given schema?

1050

How do I create a partition table in sql server?

1098

If no size is defined while creating the database, what size will the database have?

979