Subject | Re: [firebird-support] sql error |
---|---|
Author | Mercea Paul |
Post date | 2013-03-20T09:45:03Z |
On 2013.03.20 11:34 AM, Olaf Kluge wrote:
better results :
select first 1 prio from wgetnextprio
order by kount desc
into :prio_to_find;
--
Paul MERCEA
___________________________________________
E-mail: paul.mercea@...
___________________________________________
> select first 1 prio from wgetnextprio where kount = (select max(kount)I can't say anything about your error but i think this query can get
> from wgetnextprio)into :prio_to_find;
better results :
select first 1 prio from wgetnextprio
order by kount desc
into :prio_to_find;
--
Paul MERCEA
___________________________________________
E-mail: paul.mercea@...
___________________________________________