(Sum(Sum(MarkU)))/5

•

What is DaniWeb IT Discussion Community?

You're currently browsing the MS SQL section within the Web Development category of DaniWeb, a massive community of 429,818 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 3,381 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.

Join our community!

Please support our MS SQL advertiser: Programming Forums

(Sum(Sum(MarkU)))/5

•

Join Date: Jan 2008

Location: India

Posts: 160

Reputation: sbv is an unknown quantity at this point

Rep Power: 1

Solved Threads: 7

sbv

Offline

Junior Poster

(Sum(Sum(MarkU)))/5

Mar 8th, 2008

Hi

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

or

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.

Please guide...

Thanks in advance.