Re: nested sql

From: hpuxrac <>
Date: Sat, 9 Aug 2008 16:56:34 -0700 (PDT)
Message-ID: <>

On Aug 9, 1:36 pm, Shirley Cohen <> wrote:
> Hi,
> I need help with a sql statement. Suppose I have a table
> movies(movie_title, movie_rating, date_rated, user) and I want to find
> the highest ranked movies for each user. Rather than write several sql
> statements, I'd like perform this query in a single nested sql
> statement. Does anyone know how to do that?
> Thanks,
> Shirley

What version of oracle exactly?

Analytic functions can do this pretty easily. Even without many of the analytics you can do this in 1 sql statement.

This sounds very much like a homework problem though. What sql have you come up with so far? Received on Sat Aug 09 2008 - 18:56:34 CDT

Original text of this message