Re: nested sql
From: hpuxrac <johnbhurley_at_sbcglobal.net>
Date: Sat, 9 Aug 2008 16:56:34 -0700 (PDT)
Message-ID: <73dea868-6b07-40de-9b78-b8ed18405ca5@f36g2000hsa.googlegroups.com>
Date: Sat, 9 Aug 2008 16:56:34 -0700 (PDT)
Message-ID: <73dea868-6b07-40de-9b78-b8ed18405ca5@f36g2000hsa.googlegroups.com>
On Aug 9, 1:36 pm, Shirley Cohen <shirley.co..._at_gmail.com> 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