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, the same rank must be

given to these students.

Consecutive ranks must be skipped when the same rank is assigned.

Which Transact-SQL query should you use?

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, the same rank must be

given to these students.

Consecutive ranks must be skipped when the same rank is assigned.

Which Transact-SQL query should you use?

Accepted Answer

A. SELECT StudentCode as Code,

Answer

B. SELECT Id, Name, Marks, DENSE_RANK () OVER (ORDER BY Marks DESC) AS Rank

Answer

C. SELECT StudentCode as Code,

Answer

D. SELECT StudentCode as Code,

Answer

E. SELECT StudentCode AS Code,Marks AS Value

Answer

F. SELECT StudentCode AS Code,Marks AS Value FRCM (

Answer

G. SELECT StudentCode AS Code,Marks AS Value FROM

Answer

H. SELECT StudentCode AS Code,Marks AS Value FROM

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…

Question

Options

How the community answered

Community Discussion