Hi,

 

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

 

Any ideas?

 

Thanks in advance

 

Maya