Subject RE: [firebird-support] Re: 4 most recent detail rows per master row
Author Leyne, Sean
Sasha,

> What you
> did is get all details where detail.id matches master.id, but that
will
> always return all rows.

No, it won't the FIRST 4 syntax will restrict the number of details that
the query will return.


> > Did you try it?
> >
> Yes I did. Did you? :)

Yes!!!

I created an equivalent database which I have millions of rows.


Sean