agrupar en una consulta

[leonardo_josue]

Hola gerardinio:

Puedes intentarlo así:

Código MySQL:

mysql> SELECT * FROM tabla;
+-----------+------------------+-------+
| event_id  | BSP              | ipmin |
+-----------+------------------+-------+
| 104968490 |               22 |    18 |
| 104968490 |               29 |    17 |
| 104968490 | 13.2209554337407 |  1.01 |
| 104968490 | 409.938621082433 |   340 |
| 104968488 |      7.570133308 |   6.6 |
| 104968488 |             2.16 |   202 |
| 104968488 |   677.8387292564 |   500 |
| 104968486 | 38.5307160318063 |    38 |
| 104968488 |    530.396331099 |   320 |
| 104968488 | 52.6482694447864 |    38 |
+-----------+------------------+-------+
10 rows in set (0.00 sec)
 
mysql> SELECT T1.* FROM tabla T1
    -> INNER JOIN
    -> (SELECT event_id, MIN(bsp) min_bsp
    -> FROM tabla GROUP BY event_id) T2
    -> ON T1.event_id = T2.event_id AND T1.bsp = T2.min_bsp;
+-----------+------------------+-------+
| event_id  | BSP              | ipmin |
+-----------+------------------+-------+
| 104968490 | 13.2209554337407 |  1.01 |
| 104968488 |             2.16 |   202 |
| 104968486 | 38.5307160318063 |    38 |
+-----------+------------------+-------+
3 rows in set (0.16 sec)
 

El ejemplo está para MySQL, pero debería funcionar para cualquier DBMS.

Saludos
Leo.