> Hello,
>
> how can i realize this in firebird?
>
> A table with a field which can have the Value A, B or C. Now, in the table
> can be 100 records with A, 50 with B and 30 with C. How can I select this in
> firebird in a simple way without:

SELECT FIRST 1 value, COUNT(*)
FROM table
GROUP BY 1
ORDER BY 2

Pepak