Subject | List function, how to sort (FB 2.1) |
---|---|
Author | rj1102 |
Post date | 2007-07-22T08:15:39Z |
Dear all,
I like the new list function in FB 2.1.0.
But how do I sort the values within the list result?
I've tried an embedded select:
SELECT MyField1, List(MyField2)
FROM (SELECT MyField1, MyField2 FROM MyTable ORDER BY MyField1,
MyField2)
GROUP BY MyField1
But this gives the same result as:
SELECT MyField1, List(MyField2)
FROM MyTable
GROUP BY MyField1
Kind regards,
Robert
I like the new list function in FB 2.1.0.
But how do I sort the values within the list result?
I've tried an embedded select:
SELECT MyField1, List(MyField2)
FROM (SELECT MyField1, MyField2 FROM MyTable ORDER BY MyField1,
MyField2)
GROUP BY MyField1
But this gives the same result as:
SELECT MyField1, List(MyField2)
FROM MyTable
GROUP BY MyField1
Kind regards,
Robert