Try
SELECT TOP 1 count(fechaingreso) as fecha
FROM registroempresas
group by fechaingreso
ORDER BY 1 DESC
>hello, i have this query:
>
>SELECT count(fechaingreso) as fecha
>FROM registroempresas
>group by fechaingreso
>
>what i trying to do is find how many people appears in my table in a date range and from that extract the maximum of the values.
>Right now it shows 42, 1, 3, 2, etc., but i need to choose only the 42 from there, how can i do this?
--sb--