Subject | AW: [firebird-support] max count question |
---|---|
Author | Olaf Kluge |
Post date | 2011-06-02T17:04:25Z |
Hi Norman.
that's exactly what I'm looking for:
the same minimal values.
It's great.
Many thanks also to the other assistants
Best regards.
Olaf
[Non-text portions of this message have been removed]
that's exactly what I'm looking for:
>with whatever asThank you very much, also for the friendly note with the multiple rows by
>(select field_name,count(*) as kount
>from table_name
>group by field_name)
>select field_name from whatever
>where kount = (select min(kount) from whatever);
the same minimal values.
It's great.
Many thanks also to the other assistants
Best regards.
Olaf
[Non-text portions of this message have been removed]