nested sql
From: Shirley Cohen <shirley.cohen_at_gmail.com>
Date: Sat, 9 Aug 2008 10:36:49 -0700 (PDT)
Message-ID: <22b63dc5-a334-4dac-8f0a-597225dd10ab@2g2000hsn.googlegroups.com>
Date: Sat, 9 Aug 2008 10:36:49 -0700 (PDT)
Message-ID: <22b63dc5-a334-4dac-8f0a-597225dd10ab@2g2000hsn.googlegroups.com>
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 Received on Sat Aug 09 2008 - 12:36:49 CDT