I have a database of students with their results. i need to generate the rank according to the particular semester examinations within the class.
There will be maximum of 4 sections. ranks to be calculated individually.
tables which i have.
subject info -> with subject code, subject name,credit,sem.
student_univ_marks-> sem,register number,credit obtained.
13 freelancers estão ofertando em média ₹1302 para este trabalho
Hi, I just finished a similar mysql database assignment. Expert database programmer. Written many triggers and stored procedures. I can definitely help you. Thanks
Hi [url removed, login to view] your database needs is a trigger which runs whenever data about a new semester is [url removed, login to view] will then sort the student_univ_marks table(only rows where d sem column is equal) and allocate a rank to each st Mais