-
September 25th, 2011, 03:55 AM
#1
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.
Tags for this Thread
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|