Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Versions des environnements
I have a table name "Masterstudent.dbf" with fields 1. regno 2. DOB 3. category 4. Mathsmax 5. mathssec 6.Physicsmax 7.physicssec 8. chemistymax 9. chemistrysec 10. Total marks 11.rank
The Maximum marks of each subjects is 200. i put the total marks for each student using formula - (mathssec+physicssec+chemistrysec)/3.
Example
mathssec = 185, Physicssec = 190, Chemistrysec = 192 Total marks = 189
mathssec = 195, Physicssec = 185, Chemistrysec = 187 Total marks = 189
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
How to put the rank for each student?
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement