Re: How to select the <= date row?

On Thu, 06 Jun 96 13:10:09 GMT, stefanbm_at_iafrica.com (Stefan Mahs) wrote:

>Two things make this a particularly challenging problem:
>
> 1) This query has to be done from a query tool, so we are restricted to a
> single SQL statement (unless Business Objects can build a report from
> more than one SQL statement).
>
>2) Selecting the max(specified_date) where event_date <= specified_date
> works fine, but it will take a couple of days to wade through 40
> million rows.

could you try something like

set rowcount = 50
select max (specified_date) ORDER by date