Give SQL Query for this question?

ID Close
---- ------------
1 27718
2 27741
3 27661
4 27626
5 27647
6 27651
7 27685
8 27733
9 27770
10 27797
11 27893
12 27846
13 27837
14 27853
15 27835
16 27829
17 27881
18 27890
19 27868
20 27827
21 27843
22 27839
23 27828
24 27829
25 27799
26 27760
27 27779

How i can get average of close columns from id number 1 to all like 1 to 5, 2 to 6, 3 to 7, 4 to 8, 5 to 9 etc... The result should be automatically generated for further id's.

Anyone Please give me a SQL query ..Table Name is " sma ".. ( or ) give me in C# program..
Please do need full.

Good luck, most here are not in the habit of writing code for you. Try it yourself and when you have a question ask away but do not expect others to do your work for you.

Seems like a bad design to begin with. Rather than try to build the impossible, figure out what IS possible, and break it into smaller steps

This LINK may help. Then all you have to do is write the Query or C# code.

thanks for ur reply......but still i did not get idea about the query.....so please give me a related query...for this.....

Help me

Quote:

---

Originally Posted by epraveen

Help me

---

... No.

No one here will (or should) do your work for you. Try it yourself, and post here when you run into problems. Either that, or stop posting.