How to find count of repeated ids and also display different ids using sql query?

Question

How to find count of repeated country names and also display different country names using single sql query?

I have table Source_country_Table

INDIA
SPAIN
JAPAN
INDIA
US
UK
US
SPAIN
JAPAN
INDIA

for repeated ids use froup by clause. – SynozeN Technologies May 18 '17 at 11:14 — SynozeN Technologies, May 18 '17 at 11:14

score 1 · Answer 1 · answered May 18 '17 at 11:19

1

You can use below query to get the count of multiple country names

SELECT COLUMN_NAME, COUNT(*) FROM Source_country_Table
GROUP BY COLUMN_NAME HAVING COUNT(*) > 1;

Make clear of the second requirement to help you out

answered May 18 '17 at 11:19

Jim Macaulay

score 0 · Answer 2 · answered May 18 '17 at 11:19

0

Select <ID>, count(<ID>) from <TABLE> group by <ID>

Probably this should help you. Just group by serched column and count it.

answered May 18 '17 at 11:19

Kaa

score 0 · Answer 3 · answered May 18 '17 at 11:27

To show repeated country names with count:

    SELECT Country_Name, COUNT(Country_Name) as Counts FROM 
[Source_country_Table] GROUP BY Country_Name HAVING COUNT(Country_Name) > 1

To show all the country names with count:

SELECT Country_Name, COUNT(Country_Name) FROM [Source_country_Table] GROUP BY Country_Name

3 Answers3