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 many types of keys are there?

961

Is port 1433 secure?

929

Tell me what do we need queues in sql service broker?

925

What are transactions in sql?

983

What are locks in sql?

928

What are subqueries in sql server? Explain its properties.

964

How to update multiple rows with one update statement in ms sql server?

1132

What is primary key, unique key, and foreign key?

915

Why normalization is used?

958

What is the default sql server instance name?

968

what is the difference between openrowset and openquery?

1021

What is indexed view? How to create it?

930

What is difference between commit and rollback when used in transactions?

901

What are the dmvs?

950

Explain the use of containers in ssis and also their types?

905