When and How to use sub-queries

[rick pizzi]

Hi,

I'm trying to show the 6th highest scores for a larger number of players per play date. I have many play dates.

The database contains fields for id, playdate, player, and score.

The code I'm trying to produce is something like:


SELECT playdate, player, score FROM bdata FOR highst 6 scores in each playdate grouping ...

result would be like: Jan 15, 2014 player 1-6 Scores 1-6 DESC ORDER
Jan 22, 2014 player 1-6 Scores 1-6 DESC ORDER
etc.
etc.

I can only think that this query must invole sub-queries.

Any help would be appreciated.

R