min en gruop by

[iislas]

¿Esto es lo que buscas?

Código SQL:

CREATE TABLE #tutabla (clave INT, cuota INT, monto money)
 
 
INSERT INTO #tutabla (clave, cuota, monto) VALUES(575, 2, 35.00)
INSERT INTO #tutabla (clave, cuota, monto) VALUES(575, 3, 23.00)
INSERT INTO #tutabla (clave, cuota, monto) VALUES(575, 4, 75.00)
INSERT INTO #tutabla (clave, cuota, monto) VALUES(248, 1, 85.00)
INSERT INTO #tutabla (clave, cuota, monto) VALUES(248, 2, 49.00)
 
 
SELECT a.* FROM #tutabla a INNER JOIN (
 
SELECT clave, MIN(cuota) AS cuota FROM #tutabla GROUP BY clave) AS b
ON a.clave = b.clave
AND a.cuota = b.cuota
 
clave cuota monto
248 1   85.00
575 2   35.00