You are viewing a plain text version of this content. The canonical link for it is here.
Posted to ojb-user@db.apache.org by Hans Novak <hn...@repcom.de> on 2007/11/16 09:38:12 UTC

MAX statement in ojb (or mandragora)

Hi NG, Hi Alessandro :-)

How can i askt the db for a max value, like

select max(filed) from table;


Hans

---------------------------------------------------------------------
To unsubscribe, e-mail: ojb-user-unsubscribe@db.apache.org
For additional commands, e-mail: ojb-user-help@db.apache.org

Re: MAX statement in ojb (or mandragora)

Posted by Hans Novak <hn...@repcom.de>.
Danilo Tommasina schrieb:
> Hi,
>
> simply use a ReportQuery and enter "max( colName )" as column
>
Ohh... i'm stupid ;-)
Thx, it works!!

Hans

---------------------------------------------------------------------
To unsubscribe, e-mail: ojb-user-unsubscribe@db.apache.org
For additional commands, e-mail: ojb-user-help@db.apache.org

Re: MAX statement in ojb (or mandragora)

Posted by Danilo Tommasina <dt...@risksys.com>.
Hi,

simply use a ReportQuery and enter "max( colName )" as column

cheers
danilo

Hans Novak wrote:
> Hi NG, Hi Alessandro :-)
> 
> How can i askt the db for a max value, like
> 
> select max(filed) from table;
> 
> 
> Hans
> 
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: ojb-user-unsubscribe@db.apache.org
> For additional commands, e-mail: ojb-user-help@db.apache.org
> 

---------------------------------------------------------------------
To unsubscribe, e-mail: ojb-user-unsubscribe@db.apache.org
For additional commands, e-mail: ojb-user-help@db.apache.org