Hi,
Try like this.
select * from (select StudnetAdmissionNumber,
23011 as Tamil,
23012 as English,
2013 as Maths,
2014 as Science,
2015 as SocialScience
from Mark_details) x
pivot (max(MarkObtained) for SubjectId in ('23011','23012','23013','23014','23015')) AS p
Thanks