asco5 (2/7/2013)

---

hi i would like to understand how to count in sql with different parameters?

for example i have

Date, firstname, name, nationality , mode, origine, id

1/1/2010 teste teste1 fr in p 01

15/07/2005 toto tata lb out L 02

01/03/2012 teste teste1 fr in P 01

i would like to know how many poeple have the most entry in my database

for example here teste teste1 with Id 01 have the most entry it's 2 record

so i need to know the top 100 of poeple who have the most entry

result i need is for example

id 01 = 2 entry

id 02= 1 entry

thanks to help