Forum Discussion

Kiven_03's avatar
Kiven_03
Regular Visitor
2 years ago
Solved

Window Function for Student marks

Hi, I have issue in finding a solution, please help me with it.   I have a table "X_Marks", where columns are (ResultYear (ex: 2021-2022), School_ID, Roll_Number, Subject_Code, Marks). The Resul...
  • lbendlin's avatar
    lbendlin
    2 years ago

    Here is a radically different approach

    Add all marks together and then subtract the smallest mark.