Filtering a bunch of records to one after a selection has returned a bunch of them

Hi,

I am trying to establish whether or not it is possible - and how to
implement the solution - to execute an sql statement and restricting
the results to a single match even though there may be more than a
single record which matches the criteria.

e.g. select min(counter) from my_table butonlyone;

Cheers
Joe