I have a table with various scores from multiple 'users' working on the same exams. Each exams has 2 users entering scores for various sections .
What i am trying to calculate is the difference between each score per section for each exam, i noticed there's no built in difference function and i am looking for a work around. The table is data pulled from various tables, that's why its not grouped by exam
Hi @Ted
Sounds like you'll need to do that in SQL with several CTE queries.
There isn't any regular database functions for something like that, since most databases works on columns not rows.