The problem is that I don't know what it is and I don't want
something specific! I just need to use the fields value to lookup
breakpoints for presentation color coding. If I get a change in the
ALARM_GRP under one day I can show with either one.

Therefore I will use the MAX(...) for now. It will solve my problem
for this release and I will see what the customers think about the
future of this diplaying effekt.

Thanks
/Johan

--- In ib-support@yahoogroups.com, Helen Borrie <helebor@t...> wrote:
> At 08:37 AM 27/05/2003 +0000, you wrote:
> Why not use a WHERE criterion with a parameter to pick the
alarmgroup you
> want, and exclude ALARM_GRP from the output altogether, viz.
>
> SELECT blah
> from blah
> GROUP BY blah
> WHERE ALARM_GRP = ? (or :ALARM_GRP if your programming interface
allows)
>
> heLen