Re: how us top-n queries in mysql

[Sarah Sproehnle]

Maruti,

I believe you want to use ORDER BY and LIMIT. For example, to retrieve the 10 greatest populations from a table of city information you could:

SELECT * FROM city ORDER BY population DESC LIMIT 10;

Sarah Sproehnle
MySQL AB
www.mysql.com