Re: analytic functions vs subquery

Cris Carampa wrote:

> I'm trying to find a way to do that using analytic functions instead of
> a subquery.

Sorry, I should have written "instead of an inline view" instead. Of course the solution proposed by GreyBeard and Michel Cadot first came in my mind. I thought there were a way to avoid the inline view using analytic functions, but I have to admit that I misunderstood their purpose.

Thanks to everyone for their answers. Kind regards,

-- 
Cris Carampa (cris119_at_operamail.com)

- We're gonna be like three little Fonzies here. And what's Fonzie like?
- Cool?