Re: [Q] Daves's top 10 SQL question

John Griffiths wrote:
>
> SELECT
> NAME
> ,SCORE
> FROM
> StupidPetTricks
> WHERE
> ROWNUM < 11
> ORDER BY
> SCORE DESC;
>
> Regards
> John Griffiths

A more generic solution would be:

	SELECT NAME, SCORE
	FROM STUPIDPETTRICKS
	WHERE SCORE => (SELECT SCORE FROM
			STUPIDPETTRICKS WHERE
			ROWNUM = 10
			ORDER BY SCORE DESC)
	ORDER BY SCORE DESC;

However, this would not work if there were less than 10 rows and it presumes that more than 10 is ok if the last rank has ties. Received on Wed Aug 21 1996 - 00:00:00 CEST