Show all values ​​where another value is count > 1?

Question

SQL

Please help, I don’t even know how to correctly ask a question to Google



There is a table, I need to extract all call_id from it, where there is more than one value value
To roughly speaking it would be something like this

> call_id | value
> 22640 | 2
> 22694 | 2

I can describe it in words like this
: "Select a call_id where the number of value > 1 per call_id"
and exclude all values ​​where there is less than one repetition

Answer 1

group by and count, condition - having