jfc100(at)btopenworld(dot)com (Joe) wrote in message news:<88d9f4b3(dot)0112270701(dot)4a3741d(at)posting(dot)google(dot)com>...
> 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;
Ummm ... "select something from thistable limit 1".
Or is there something I'm missing here?
Calvin