second MAX and so on
| From: | Jacky | Date: | Thu, 24 May 2001 21:14:25 +0000 |
| Subject: | second MAX and so on | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-54188@lists.php.net to get a copy of this message | ||
hi people,
When I use this query below:
select result , count(result) as choice from result group by result order by choice desc;
It returns the number of times each value appear in a result field in order of DESC under variable
"choice", right?
At this point, I know how to pick MAX(choice) but how do I pick second MAX and so on to the last one
so that I can print each of them on to the position on the page as I wish?
cheers
Jack
jacky@activelifestyle.com
"There is nothing more rewarding than reaching the goal you've set for yourself"