• hi i don't want to insert

    i just need to know in my table

    who are the id that have the most record depending on their ID and date.

    each id is nunique and its for one person

    but sometimes this id is repeated depending on the date

    so on date 1 i have id 1

    on date2 i have id1

    on date 3 i have id2

    so the id have many record on different times

    i need to know how many time i have id1, and id2 etc...

    example : id 1 have 45 times recorder

    that all