i have the following query to get the second row in studentsubject table it's work well but I need another way give better performance than using subquery
select SbID , StID, max(mark)
from studentsubject
where mark <( select max(mark) from studentsubject)
group by SbID
order by mark desc
limit 5
Aucun commentaire:
Enregistrer un commentaire