Some analytic function
From: Eitan M <no_spam_please_at_nospam_please.com>
Date: Wed, 6 Feb 2008 12:01:01 +0200
Message-ID: <foc0e4$bn$1@news2.netvision.net.il>
10002 ...
Date: Wed, 6 Feb 2008 12:01:01 +0200
Message-ID: <foc0e4$bn$1@news2.netvision.net.il>
Hello.
I want to present my query in a table (it is for flat - report).
suppose there are 5 students, and several courses that each course has some
major exams (Math, English, ....)
and each column represent all the grades of all students that participated
the exam.
Course No. Math English Exam no x. Exam no. y -------------- ------------ --------- -------------- -------------
10001 Grade- ....
student-1 ...
Grade-
student-2 ..
10002 ...
Is there any analytic function for that ?
Thanks :) Received on Wed Feb 06 2008 - 04:01:01 CST