Subject AW: [firebird-support] max count question
Author Olaf Kluge
Hi Norman.

that's exactly what I'm looking for:



>with whatever as
>(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);



Thank you very much, also for the friendly note with the multiple rows by
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]