Re: nested sql
Date: Sat, 9 Aug 2008 16:56:34 -0700 (PDT)
On Aug 9, 1:36 pm, Shirley Cohen <shirley.co..._at_gmail.com> wrote:
> 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?
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