On Thu, 31 Mar 2005 10:29:16 +0800, "æï[é" <[EMAIL PROTECTED]> 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 ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
