You are given a table "students" with columns - "Name", "Subject", "Marks". Give subject-wise rankings to students using SQL.

Rank students based on their subject-wise marks using SQL.

• Use the SQL SELECT statement to retrieve the data from the 'students' table.

• Use the SQL ORDER BY clause to sort the data by subject and marks ...read more