MySQL Forums :: Cursors :: Subselect and walking throught result with cursor

SELECT r1.* FROM robots r1
  JOIN (SELECT IDaukce, MIN(counter) max_counter FROM robots r2 GROUP BY IDaukce) r2
    ON r1.IDaukce = r2.IDaukce AND r1.counter = r2.max_counter;

+----+---------+-------+---------+
| ID | IDaukce | uziv  | counter |
+----+---------+-------+---------+
|  2 |       1 | Chuck |       0 |
|  3 |       2 | Chuck |       0 |
+----+---------+-------+---------+