Posts by EliasVentura • 1 point
1 post
-
0
votes3
answers193
viewsA: Select only first place in the first half - SQL Server Code
SELECT P.Data, Nm.Nome, epp.PosicaoFinal FROM Prova P, Piloto Nm, EquipaParticipaProva epp WHERE epp.PosicaoFinal = (SELECT epp.PosicaoFinal FROM EquipaParticipaProva where epp.PosicaoFinal = 1)…