SQL statement

From: Joseph Ranseth <jransethNO_SPAM_at_worldcupfishing.com>
Date: Wed, 16 Aug 2000 14:55:38 -0500
Message-ID: <mjCm5.1355$ak3.12121_at_news1.mts.net>

[Quoted] 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
[Quoted] records associated to them, and the sum of a field of the top 4 entries are [Quoted] between 2 parameters. I want to sort the records on the sum of the top 4 records in descending order.
[Quoted] 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
            )

WHERE sum(actual_points) > 2000
AND sum(actual_points) < 5000
/

I can't figure out how to make this work.... Thanks in advance for any help!

--
Joseph

Received on Wed Aug 16 2000 - 21:55:38 CEST