country city Korea Seoul USA New York USA L.A. Germany Berlin Japan Tokyo Fance Paris USA Chicago Japan Nagoya Korea Seoul
I have a table “test” like the above.
SELECT country FROM test GROUP BY COUNTRY
The code above produces the result below.
So far, so good.
Now I like to call some record which comes more than 1 time.
The would be code below is not correct code
SELECT country FROM test WHERE country(more than 2 times) GROUP BY COUNTRY
Target result is the following
I like to get my target result with your help.