Question

Write a query to display the student names and the maximum mark scored by them in any subject, ordered by name in ascending order. Give an alias to the maximum mark as max_mark.

Answer 1

Answer:

this in micrsoft office access

Explanation:

first click new database

then click on table of data sheet

data sheet

the table is put

Answer 2

The query to display the student names and the maximum mark scored by them in any subject, ordered by name in ascending order can be given as follows:

SELECT name, MAX(mark) as max_mark FROM student_info  

GROUP BY name  

ORDER BY name ASC;

The above query is formulated on the assumption that ‘student_info’ is a table in a database and name, mark are fields in the table with string and numeric data types respectively.