SELECT *
FROM aa t1
WHERE EXISTS
(
SELECT 1
FROM aa t2
WHERE t2.tarih = t1.tarih
LIMIT 1, 1
)

AND EXISTS
(
SELECT 1
FROM aa t2
WHERE t2.pist = t1.pist
LIMIT 1, 1
)
AND EXISTS
(
SELECT 1
FROM aa t2
WHERE t2.sehir = t1.sehir
LIMIT 1, 1
)


Kısaca :


SELECT *
FROM aa t1
WHERE EXISTS
(
SELECT 1
FROM aa t2
WHERE t2.tarih = t1.tarih AND t2.pist = t1.pist AND t2.sehir = t1.sehir
LIMIT 1, 1
)