declare @counting table ([date] date, firstname char(10), name char(10), nationality char(2), mode char(3), origine char(1), ID char(2))

INSERT INTO @counting values

('2010-01-01','teste','teste1','fr','in','p','01'),

('2005-07-15','toto','tata','lb','out','L','02'),

('2012-03-01','teste','teste1','fr','in','P','01')

SELECT

ID,

COUNT(ID) MyCount

FROM

@counting

GROUP BY ID

ORDER BY MyCount DESC