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

2015-07-29 Thread setysvar setys...@gmail.com [firebird-support]
>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 > >IDGroupID FKCode Value >1 1 ABC

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

2015-07-29 Thread 'Raffaele Confalone' r.confal...@libero.it [firebird-support]
: [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 IDGroupID FKCode

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

2015-07-29 Thread Maya Opperman m...@omniaccounts.co.za [firebird-support]
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 IDGroupID FKCode Value 1 1