Hi
I have a table consisting of a column with values less than 100.
What I would like to do is use the value "100" and subtract them from my
column.
How do I write the SQL query such that 100 is considered a unique number
that needs to apply to all of the rows.
I know that creating a column consisting of 100's repeated for all rows and
subtracting them from the other column with values less than 100 would work.
Is there a shorter, more unique way of running a query for this?
Thanks.
Regards.
Vinesh Govind
NBS - Marketing
(T) 364 2106
(F) 364 2915
Email: [EMAIL PROTECTED]
WARNING:
Any unauthorised use or interception of this email is illegal. If this email
is not intended for you, you may not copy, distribute nor disclose the
contents to anyone. Save for bona fide company matters, the BoE Group does
not accept any responsibility for the opinions expressed in this email.
For further details please see: http://www.nbs.co.za/emaildisclaim.htm
Notebook.jpg
Notebook.jpg