select A.* from ( select stdno, score from score where subjectId = 3 order by score desc) B inner join score A on A.stdno = B.stdno order by B.score desc
select A.* from ( select stdno, score from score where subjectId = 3 order by score desc) B inner join score A on A.stdno = B.stdno order by B.score desc, A.subjectId asc
select * from score s order by (select score from score where stdno=s.stdno and subject=3) desc, a.subject
select stdno, score from score where subjectId = 3 order by score desc) B
inner join score A
on A.stdno = B.stdno order by B.score desc
select stdno, score from score where subjectId = 3 order by score desc) B
inner join score A
on A.stdno = B.stdno order by B.score desc, A.subjectId asc
from score s
order by (select score from score where stdno=s.stdno and subject=3) desc,
a.subject