You create a table that has the StudentCode, SubjectCode, and Marks columns to record mid-year marks for students. The table has marks obtained by 50 students for various subjects.
You need to ensure that the following requirements are met:
Students must be ranked based on their average marks.
If one or more students have the same average, incremental ranks must be given based on the order they are created. Ranks must be sequential without gaps in between.
Which Transact-SQL query should you use?
A.
B.
C.
D.
E.
F.
G.
H.