Note: This question is part of a series of questions that use the same or similar answer choices. An answer choice may be correct for more than one question in the series. Each question is independent of the other questions in this series. Information and details provided in a question apply only to that question.
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.
Comments