Subject Re: [firebird-support] sql error
Author Mercea Paul
On 2013.03.20 11:34 AM, Olaf Kluge wrote:
> select first 1 prio from wgetnextprio where kount = (select max(kount)
> from wgetnextprio)into :prio_to_find;
I can't say anything about your error but i think this query can get
better results :

select first 1 prio from wgetnextprio
order by kount desc
into :prio_to_find;


--
Paul MERCEA
___________________________________________

E-mail: paul.mercea@...

___________________________________________