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

what is your expected result in case of ties? Is it ok to randomly pick subjects?

  • Kiven_03's avatar
    Kiven_03
    Regular Visitor
    2 years ago

    Hi lbendlin ,
    Thank you for your reply,
    I was trying to get the total of top5 subject marks out of 6 subjects of a student,

    but thing is in student's Marks Table of 3 academic years  where student roll in not unique, but unique in each academic year.

     

    Thank you. 

    • 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