Rif: [firebird-support] Possible to use FIRST 1 inside a group by?

Wed, 29 Jul 2015 05:07:50 -0700 

This is solution: 
select * from tabella A where Group_ID in (Select min(Group_ID) in tabella B
where B.ID=A.ID);
 
 
 
 
-------Messaggio originale-------
 
Da: Maya Opperman [email protected] [firebird-support]
Data: 29/07/2015 13.49.41
A: [email protected]
Oggetto: [firebird-support] Possible to use FIRST 1 inside a group by?
 
  
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

 

[Non-text portions of this message have been removed]

Reply via email to