Query

[rdevalapelly]

Hi,

I need to write a query here is the data to be retrived

There is a data base table of Employees having fields firstname,lastname and all the other details.

i have to retrive the all the firstnames of all the employees in alphabetical order and the number of times the first name repeats.

for example

Bobe is the first name repeats three times.

i should get Bobe 3

[YuckFou]

select firstname , count(*) as duplication
from Employees
group by firstname