Código SQL [-]Select fecha, cancha from tabla as tbl where fecha in (select top 3 fecha from tabla where cancha = tbl.cancha order by fecha) order by cancha, fecha
Select fecha, cancha from tabla as tbl where fecha in (select top 3 fecha from tabla where cancha = tbl.cancha order by fecha) order by cancha, fecha