esse,
Tino
-Ursprüngliche Nachricht-
Von: Thomas Fischer [mailto:[EMAIL PROTECTED]
Gesendet: Montag, 22. November 2004 13:07
An: Apache Torque Users List
Betreff: RE: Antwort: SQL->Criteria howto
Hi Tino,
(alternative solution, just got Richard's answer but decided to send this
6753711
any hints how to "carve" that into a criteria?
Thanks 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,
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
hould be selected: max(send_sequenz) from every sequenz
VAVI_ID AUFT_ID SEQUENZ SEND_SEQUENZ
91329 67537 2 2
91330 67537 1 1
any hints how to "carve" that into a criteria?
Thanks again,
Tino
-Ursprüngliche Nachricht-
1
any hints how to "carve" that into a criteria?
Thanks 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&#x
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
e, it was just my
first thought...
thank you,
Tino
-Ursprüngliche Nachricht-
Von: Thomas Fischer [mailto:[EMAIL PROTECTED]
Gesendet: Montag, 22. November 2004 11:54
An: Apache Torque Users List
Betreff: Antwort: SQL->Criteria howto
Hi Tino
1) I do not understand why you need t
Hi Tino
1) I do not understand why you need the alias. Following sql works for me
(on tutorial tables, on oracle)
select * from book where book_id in (select max(book_id) from book);
Thomas
"Sperlich, Tino" <[EMAIL PROTECTED]> schrieb am 22.11.2004
11:40:18:
> Hi all,
>
> I'd like to expr
