Calculate on itself
only one table A(autoid, number)
how SELECT statment result: B(autoid, number, numberB)
numberB is sum of all the number have autoid > its autoid.
June 13th, 2011, 03:02 AM
If you have only one table A, then what is B ?
June 13th, 2011, 01:34 PM
If you review your SQL 101 course, you will be able to easily answer this homework assignment.
Originally Posted by swordsaint
June 13th, 2011, 06:14 PM
from my head , something like this.....
June 13th, 2011, 08:16 PM
Unfortunately you were given the answer and did not learn anything.
Some people do not understand the knowledge of the ages:
"Give a man a fish and he will eat one day, Teach a man to fish and he will have food every day"
Comments on this post