Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> SQL statement
Hello all,
I need to build a fairly complex SQL statement, and I need some help.
I want to pull all the entries for each user from a table, where a user has
at least 4
records associated to them, and the sum of a field of the top 4 entries are
between 2 parameters. I want to sort the records on the sum of the top 4
records in descending order.
Something like this (although I know this doesn't work)
SELECT sum(actual_points),
player_name
FROM (SELECT ROWNUM as Rank,
player_name, actual_points FROM (SELECT player_name, actual_points FROM entries_table ORDER BY actual_points DESC ) WHERE rank > 5 )
I can't figure out how to make this work.... Thanks in advance for any help!
-- JosephReceived on Wed Aug 16 2000 - 14:55:38 CDT