>When more than one student have got same total marks, the inter-Se merit among each student will be determine the order of priority as given below
>1. student got Highest marks in Mathssec
>2. student got Highest marks in physicssec
>3. student got Highest marks in chemistrysec
>4. Student DOB
Is this select statement what you need:
SELECT * from MasterStudent ORDER BY TotalMarks DEC, MathsSec DEC, PhysicsSec DEC, ChemistrySec DEC
Otherwise, could you give some more info?