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 express
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
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' answer may
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' answer may
:30
An: Apache Torque Users List
Betreff: Re: Antwort: SQL-Criteria howto
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
:30
An: Apache Torque Users List
Betreff: Re: Antwort: SQL-Criteria howto
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
-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
anyway)
ok, again