Thread: Select query retireve smallest number

I have the folowing table:

DATA TotalCount
A 0
B 15
C 0
D 2
E 8

The field "TotalCount" can contain many duplicates. I to select one record with the smallest number.
In this case, an example would be:
A 0

I tried the folowing query but it returned more than one record:

SELECT TOP 1 rndnumbers
FROM query1_qse
ORDER BY query1_qse.TotalCount ASC;

Thank you.

Perhaps:

SELECT TOP 1 DATA, TotalCount FROM query1_qse WHERE TotalCount = (SELECT MIN(TotalCount) FROM query1_qse)