Note: This question is part of a series of questions that use the same set of answer choices. An answer choice may be correct for more than one question in the series.
You create a table that has three columns named StudentCode, SubjectCode, and Marks. The Marks column records grades for students expressed as a percentage. The table has marks obtained by 50 students for various subjects.
You need to retrieve the StudentCode and Marks for students who scored the lowest percentage for each subject.
Which Transact-SQL query should you use?
A.
B.
C.
D.
E.
F.
G.
H.
lilupv
4 years, 11 months ago