Retrieve the second highest marks obtained by each student from a table with student name, subject, and marks.

• Use the RANK() function to assign a rank to each row based on the marks in descending orde...read more