I want to collect duplicated values in SQL and convert them to a number

Question

I want to count a certain value in a column and output it as a number. Here is an example:

id	job
1	police
2	police
3	ambulance

Now I want to count the value "police" in the "job" column and make the result in a number, so because there are two entries with "police" in the column it would be as output the number two. With the value "ambulance" it is only one entry so the result would be 1.

Can anyone tell me how to write this as code? I have now searched a lot on the Internet and tried myself but I have found nothing that worked.

A [mcve] should also contain the expected result. And don't forget to add a dbms tag. — jarlh, Sep 06 '22 at 20:14

score 0 · Accepted Answer · answered Sep 06 '22 at 20:12

0

You're saying you want to count how many of each type of job there is, right?

SELECT COUNT(*), job
FROM tablename
GROUP BY job

answered Sep 06 '22 at 20:12

Andy Lester

91,102
13
100
152

Thanks for the quick reply. But can you tell me how I can count only the value "police"? – Cabonie Sep 06 '22 at 20:17
You'll want to use a "WHERE" clause for that instead of the GROUP BY. – Andy Lester Sep 06 '22 at 20:22
`having count(*) > 1`? – shawnt00 Sep 06 '22 at 20:23

I want to collect duplicated values in SQL and convert them to a number

1 Answers1