mercredi 1 avril 2015

query in sqlite about second row

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