SELECT city,jname FROM j
WHERE city IN
(
SELECT city FROM j
GROUP BY city
HAVING COUNT(city)>1
)
ORDER BY city ASC,jname ASC;
SELECT city,jname FROM j
WHERE city IN
(
SELECT city FROM j
GROUP BY city
HAVING COUNT(city)>1
)
ORDER BY city ASC,jname ASC;