Question

Get the 6 subjects in more student marks and display total marks and pass or fail program in c

Answer 1

Answer:

I have the following table

Name | Subject | Marks

--------------------------

a M 20

b M 25

c M 30

d C 44

e C 45

f C 46

g H 20

Here I have a "Student" table I want to get the Name of the student who got

Max marks from each subject from the student table like the following OUTPUT.

Name | Subject | Marks

c M 30

f c 46

g h 20