С MS SQL нямам опит, но предполагам, че има вложени заявки, с които, както написах по-горе, можеш да постигнеш същия ефект:

kouber=# select max(A.a_id) as a_id, A.b_id, A.c from

         (select b_id, max(c) as c from A group by b_id) as x1 

         inner join A on A.b_id=x1.b_id and A.c=x1.c

         group by A.b_id, A.c;



 a_id | b_id | c

------+------+----

    8 |    1 |  3

   10 |    2 | 10

    9 |    3 |  8

(3 rows)



kouber=# select min(A.a_id) as a_id, A.b_id, A.c from

         (select b_id, max(c) as c from A group by b_id) as x1 

         inner join A on A.b_id=x1.b_id and A.c=x1.c

         group by A.b_id, A.c;



 a_id | b_id | c

------+------+----

    2 |    1 |  3

   10 |    2 | 10

    6 |    3 |  8

(3 rows)

Редактирано от Dakota на 25.08.05 14:35.