RE: Antwort: SQL->Criteria howto

2004-11-22 Thread Thomas Fischer
again, > Tino > > -Ursprüngliche Nachricht- > Von: Richard Bayet [mailto:[EMAIL PROTECTED] > Gesendet: Montag, 22. November 2004 12:30 > An: Apache Torque Users List > Betreff: Re: Antwort: SQL->Criteria howto > > > Hi all, > > Thomas' answer may not be ver

Re: Antwort: SQL->Criteria howto

2004-11-22 Thread Richard Bayet
Hi all, Thomas' answer may not be very accurate (it's simpler than Tino what Tino's need), but "select vavi_id, max(sequenz) from voravis where vavi_id = 67537" should be fine. Of course, if you (Tino) want the max(sequenz) for every distinct vavi_id, you'll need the IN clause. Thomas Fischer a