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

['Leyne, Sean' s...@broadviewsoftware.com [firebird-support]]

Maya,

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

Unfortunately, it is least efficient method -- you will read each table row n^2 
times

Try:

SELECT
  T.ID
  T.GroupID
  T2.FKCode
  T2.Value
FROM (
    select MIN (ID) as ID, GroupID
    from MyTable
    GROUP BY GroupID
  ) T
  JOIN MyTable T2 ON T2.ID = T.ID


Sean