how to get avg weight based on day?

Question

1.33/5 (2 votes)

See more:

SQL-Server-2008R2

I want to display avg weight..based on last month sunday dates only...

C#

sno    name     weight     date     avgweight
1      aaa       100    06/07/2014     
1      aaa       200    13/07/2014     200(it's a 3 sunday's avg weight)
1      aaa       300    20/07/2014

how to get average weight based on sunday...
how can i achive this..

please help me?

Posted 6-Aug-14 23:24pm

ramaraog96

Updated 6-Aug-14 23:33pm

v3

Add a Solution

Comments

Dilan Shaminda 7-Aug-14 5:55am

have you tried anything so far? where did you stuck?

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Magic Wonder · Answer 1 · 2014-08-07T00:01:00

Solution 1

Hi,

Check this Link[^]. And look for Avg().

Hope this will help you.

Cheers

Posted 7-Aug-14 0:01am

Magic Wonder

Comments

Magic Wonder 7-Aug-14 6:03am

First you try yourself, if got stuck then you can be back with your query.

danigeraleddin · Answer 2 · 2014-08-07T05:03:00

Solution 2

Hi, You can use something like the query below and improve it,

SQL

SET DATEFIRST 1;
select avg(weight) from your_table
group by DATEPART( dw, date)

The function

DATEPART( dw, date)

returns a number from 1 to 7 where 1 is Monday and 7 Sunday

Posted 7-Aug-14 5:03am

danigeraleddin

Updated 7-Aug-14 5:09am

v3