nested sql

From: Shirley Cohen <>
Date: Sat, 9 Aug 2008 10:36:49 -0700 (PDT)
Message-ID: <>


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?


Shirley Received on Sat Aug 09 2008 - 12:36:49 CDT

Original text of this message