Expand|Select|Wrap|Line Numbers
- SELECT *
- FROM StudentsExams;
Expand|Select|Wrap|Line Numbers
- SELECT (SELECT Count(*)
- FROM StudentsExams As X
- WHERE X.classid = StudentsExams.classid
- and x.PaperID = StudentsExams.PaperID
- And X.Result > StudentsExams.Result)+1 AS Ranks, *
- FROM StudentsExams;
Please what is the reason behind it and any alternate for it please?
Moreover when I create a report based on the 2nd query, multilevel grouping fails. Any help will be appreciated.
Another issue is: This query results in ranks as:
Expand|Select|Wrap|Line Numbers
- StudentID ClassID PaperID Result Rank
- 1 1 1 10 1
- 2 1 1 12 2
- 3 1 1 12 2
- 4 1 1 13 4
Expand|Select|Wrap|Line Numbers
- StudentID ClassID PaperID Result Rank
- 1 1 1 10 1
- 2 1 1 12 2
- 3 1 1 12 2
- 4 1 1 13 3