in mysql we can do smth like this
SELECT name
FROM (
SELECT name,
COUNT(*) AS COUNT
FROM Passenger
GROUP BY name
) AS NAMES
WHERE COUNT > 1
in mysql we can do smth like this
SELECT name
FROM (
SELECT name,
COUNT(*) AS COUNT
FROM Passenger
GROUP BY name
) AS NAMES
WHERE COUNT > 1