Re: EOF & DB Aggregation functions

On 22 Oct 2006, at 15:31, Randy Wigginton wrote:

> I've done a number of internet searches and cannot seem to find any  
> information, though I thought I had read something about this...
>
> I need to perform an operation something like this:
> select sum(time), sum(counter), max(time) from mytable where key1=?  
> and key2=?
>
>
> Is there a "nice" way to do this, other than rawRowsForSql?  And if  
> rawRowsForSQL is the only option, is there a way to perform a bind,  
> rather than building the sql string dynamically?

You can define a named query that uses raw sql.

Paul