Question

display name of student whose minimum marks ​

Answer 1

Answer:

Select min(marks) from student;

Explanation:

Assuming that "student" table has an "marks" column run the mentioned query for the desired value.

• min() returns minimum value of that specific column.
• Select returns the values on screen.

Answer 2

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

Explanation:

hope its help full for you