Counting the greatest number

[peljo]

I want to build a query with which to find the greatest number of figures in the field.I have a field called Plates where single numbers are entered.For example

Visits Plates
John 3
Jim 3
Deuce 3
Liza 3
Lenny 1
Lorry 6

Obvisouly in the above example we can count that the number 3 is the biggest number.
How can i express that in a query ?

 

[r937]

select top 1 Plates, count(*)
from daTable
group by Plates
order by count(*) desc

r937.com | rudy.ca