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

On Feb 6, 4:01*am, "Eitan M" <no_spam_please (AT) nospam_please (DOT) com> wrote:
What, exactly do you mean by 'Is there any analytic function for
that ?' For what? Your question is far from clear or concise.


David Fitzjarrell

On Feb 6, 4:01*am, "Eitan M" <no_spam_please (AT) nospam_please (DOT) com> wrote:
What, exactly do you mean by 'Is there any analytic function for
that ?' For what? Your question is far from clear or concise.


David Fitzjarrell

On Feb 6, 4:01*am, "Eitan M" <no_spam_please (AT) nospam_please (DOT) com> wrote:
What, exactly do you mean by 'Is there any analytic function for
that ?' For what? Your question is far from clear or concise.


David Fitzjarrell

On Feb 6, 4:01*am, "Eitan M" <no_spam_please (AT) nospam_please (DOT) com> wrote:
What, exactly do you mean by 'Is there any analytic function for
that ?' For what? Your question is far from clear or concise.


David Fitzjarrell

select ..., rank () over ( ...)


something of above is an analytic function.

I don't know what is the best way to do a good query for the above.

Need some help, please.

Thanks

select ..., rank () over ( ...)


something of above is an analytic function.

I don't know what is the best way to do a good query for the above.

Need some help, please.

Thanks

select ..., rank () over ( ...)


something of above is an analytic function.

I don't know what is the best way to do a good query for the above.

Need some help, please.

Thanks

select ..., rank () over ( ...)


something of above is an analytic function.

I don't know what is the best way to do a good query for the above.

Need some help, please.

Thanks

On Feb 6, 9:50*am, "Eitan M" <no_spam_please (AT) nospam_please (DOT) com> wrote:
I know what analytic functions ARE, I do NOT know what 'that' is in
your original question. Either clearly describe your problem and the
solution you expect to see or expect very little in assistance.


David Fitzjarrell