>hi all,
>
>I have this query:
>
>Select a, b, c from MyTable;
> into array MyArray;
> where a=MyKey
>
>
>If there are serveral matches in the table, how should I modify this query in
>order to get the last matched one?
One way to do this would be to use the
TOP 1
and the
ORDER BY myField DESCENDING
clauses.