CREATE TABLE railway (LOCATION VARCHAR2)

Show the locations that have more than one railways.
SELECT LOCATION FROM railway GROUP BY LOCATION HAVING COUNT(*) > 1
SELECT "LOCATION" FROM "railway" GROUP BY "LOCATION" HAVING COUNT(*) > 1