db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Bryan Pendleton <bpendle...@amberpoint.com>
Subject Re: What's the name of a column...
Date Wed, 14 Nov 2007 16:49:22 GMT
>   I execute a query like this: select MAX(idstat) from history;
> 
>   Now, from the ResultSet, how can I get the data by column name?

Try using the "as" keyword to provide a name for your column:

   select max(idstat) as max_idstat from history;

Then you should be able to fetch the data by column name "max_idstat".

thanks,

bryan



Mime
View raw message