Re: A SQL Question About distinct, limit, group by, having, aggregate

On Thu, 31 Mar 2005 10:29:16 +0800, "林�[鋅" <s9154083(at)cyut(dot)edu(dot)tw> wrote:
> i have a little question, how to get 3 higher score student in every class.
> Data looks like as below
>
> problem:
> id class score
> john a 100
> jenny a 70
> ken a 59
> mary b 85
> jacky b 80
> lily b 70
> kevin b 50
> david b 30
> tina c 85
> tony c 80
> bare c 70
> vivian c 60
> eric c 57
> andy c 50
>
> result:
> id class score
> john a 100
> jenny a 70
> ken a 59
> mary b 85
> jacky b 80
> lily b 70
> tina c 85
> tony c 80
> bare c 70
>
Actually, i don't see any difference between problem and results but maybe

select * from yourTable order by class, score desc

regards,
Jaime Casanova