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...
Need Help
  • lbendlin's avatar
    lbendlin
    2 years ago

    Here is a radically different approach

    Add all marks together and then subtract the smallest mark.

     

lbendlin's avatar
lbendlin
Super User
2 years ago

let's say you have the following marks

 

87,87,83,83,83,83

 

What in your opinion should be the top 5 subjects?

Kiven_03's avatar
Kiven_03
Regular Visitor
2 years ago

Thanks for your reply lbendlin ,

87,87,83,83,83 should be my total of Top5 Subjects and one subject marks needs to be eliminated '83'. 

But now I got new doubt, thank you for your valuable reply.

 

Anyhave please help me with the current senario.

 

Thank you

Vivek