i have created a table "stu" in which the following record exists. stu_id,stu_name,stu_course,stu_marks
the stu_marks column output is as follows
822 758 789 658 822 879 598 825 589 785 795 795 658 789 988
what i want is to write query or code (function,procedure or anything) that when i execute it prompts the user to enter whether he want to have top 10 students marks(according to marks),top 5,top 3,2,1 inshort from top1-top15 and when he enters top1 so the highest marks of the student should be displayed,similary if user enters top 10 so the 10 studnets marks will be displayed in descending order i would be grateful to you if u kindly do it
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!