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?