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 do you mean by an execution plan?

1093

Explain indexes disadvantages?

1065

What is use of except clause?

1070

How we create SQL Server 2005 Reporting Services ? Give me Sample

1974

What are system databases into sql server (2005/2008) : sql server database administration

996

what are isolation levels? : Sql server database administration

969

Different types of keys in SQL?

1082

What happens if null values are involved in bitwise operations?

993

Explain what are sparse columns?

970

What is partition in sql server?

1021

What is the Control Flow in SSIS

1073

Explain different types of Normalization.

1803

List all the types of user-defined functions?

1070

Call by value and call by reference in procedure and function, with NOCOPY.

1283

Can you type more than one query in the query editor screen at the same time?

989