Detailed course structure for each branch and semister
Syllabus for each semester subjects
Previous Mid Exam Question Papers
Previous Semesters Final Exam Question Papers
You can't have a order by clause in a Sub-Query ?
ORDER BY Clause (Transact-SQL)
Specifies the sort order used on columns returned in a SELECT statement. The ORDER BY clause is not valid in views, inline functions, derived tables, and subqueries, unless TOP is also specified.