select *
from
(
select row_Number() over (partition by fullname,course order by semester desc) as seq,columns..
from table
)t
order by fullname,course,seq

quote:

---

Originally posted by jassi.singh

Hi, You can make a simple modification in previous message query i.e. instead of including fullname in partition by clause use studentnumber column of your table

Please mark answer as accepted if it helped you.

Thanks,
Jassi Singh

---