MySQL "Top N Percent" Equivelant

[Akumadevil]

Hi,
I realise MySQL doesn't have a SELECT TOP 10 PERCENT ... function, but was wondering is there another way to do this?

A generic query like below will return the 5 tallest people. But what about the top 10% of tallest people?

SELECT name, height
FROM people
ORDER BY height DESC
LIMIT 5


Any help would be appreciated,
thanks.

 

[mrdenny]

You'll want to post this in the MySQL forum.

Denny
MCSA (2003) / MCDBA (SQL 2000)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com