Question

How to write sql query for 'display highest average marks' from table Student?

Answer 1

Answer:

Select max(average_marks)from student;

Explanation:

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

• max() returns maximum value of that specific column.
• Select returns the values on screen.