>I’ve got quite a tricky SQL query (well, at least for me it is, I’m hoping someone may have done this before)

 

>Here’s a simplified example of what I’m trying to do:

 

>I have a table with

 

ID            GroupID               FKCode                 Value

1              1                              ABC                        +5

2              1                              XYZ                         -5

3              2                              ABC                        +8

4              2                              XYZ                         -8

5              3                              ABC                        -2

6              3                              XYZ                         +2

 

>I’d like to select the first record of each group, eg.

 

ID            GroupID               FKCode                 Value

1              1                              ABC                        +5

3              2                              ABC                        +8

5              3                              ABC                        -2

 

I think I just solved my own problem.

 

Might not be the most efficient method, but this works:

 

select ID, GroupID, FKCode, Value

from MyTable T

where T.ID = (select first 1 T2.ID from MyTable T2 where T.GroupID = T2.GroupID order by T2.ID)