SQL.Subquery

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
This entry was posted in Без рубрики. Bookmark the permalink.