Hi All,
I need a count of how many times certain field value appears in my table.
Here is my code

Select *, count(*) as counter
Group by keyfield

This gives me an error, thus how can I use group by on only one filed and still select rest of fields?