I want to write a query which will return me Sum(MarkU) and also the avg.
Which is something like (Sum(Sum(MarkU)))/5 in mathematically operation
TotMark = Sum(MarkU)
AvgMark = TotMark / 5
I hope you get an idea what i need.
How to write this type of query in Db ?
I am using that query for Crystal report.
I tried to get this by using Formula field. But that formula field returning me the result of all rows not for a single row.
Thanks in advance. :)