Re: RgueWave and Join two Table
From: Theo Peterbroers <peterbroers_at_floron.leidenuniv.nl>
Date: 18 Oct 2001 08:10:12 -0700
Message-ID: <39bb2c10.0110180710.131df511_at_posting.google.com>
Date: 18 Oct 2001 08:10:12 -0700
Message-ID: <39bb2c10.0110180710.131df511_at_posting.google.com>
Josef Böhm <boehm_at_fct.de> wrote in message news:<3BCEA7CE.54EB7FDA_at_fct.de>...
> How can I make the following statement with the RougueWave BDTool++ ?
>
> SELECT *
> FROM TableObj, (select objnr as OBJ_NR, MAX(version) as MAX_NR from
> TableObj Groupby objnr)
> WHERE objnr = OBJ_NR and version = MAX_NR
>
> Do someone has an other idea to make this statement ?
>
> Thanks Josef Boehm
SELECT objnr AS OBJ_NR, MAX(version) as MAX_NR
FROM TableObj as t
GROUP BY objnr
Other SELECTED columns must also be specified in GROUP BY Received on Thu Oct 18 2001 - 17:10:12 CEST