-
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.
-
September 25th, 2011, 09:12 AM
#2
Re: Give SQL Query for this question?
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.
Always use [code][/code] tags when posting code.
-
September 25th, 2011, 01:19 PM
#3
Re: Give SQL Query for this question?
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
-
September 25th, 2011, 09:16 PM
#4
Re: Give SQL Query for this question?
This LINK may help. Then all you have to do is write the Query or C# code.
Rob
-
Ohhhhh.... Old McDonald was dyslexic, E O I O EEEEEEEEEE.......
-
September 25th, 2011, 11:00 PM
#5
Re: Give SQL Query for this question?
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
-
September 26th, 2011, 01:52 AM
#6
Re: Give SQL Query for this question?
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.
It's not a bug, it's a feature!
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
|