estdecimal;
_
version 4.1.12
1468.
version 5.0
999.
Shantanu Oak
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
150
soak | D | 900 | 400 | 500 | 2003-03-25 | 300
and if it is possible, the second last entry if the stock > bought like this...
ccode |symbol | buy | sell | stock | transaction_date | bought
soak | A | 300 | 275 | 25 | 2003-09-02 | 150
soak | D | 900 | 400 | 500 | 2003-03-25 | 300
soak | D | 900 | 400 | 500 | 2002-02-25 | 100
soak | D | 900 | 400 | 500 | 2001-03-25 | 100
Note: even if 500 quantity was bought on 2001-03-25 I want to display only 100
in the bought column above because 400 units have already been sold off.
Thanks
Shantanu Oak
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
some server incompatibility.
Shantanu Oak
[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Dear Sir,
I have written a paper on Mysql http://en.wikibooks.org/wiki/Programming:MySQL
Will you please go through it and make corrections where ever necessary?
Shantanu Oak
[EMAIL PROTECTED]
http://oksoft.blogspot.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com
Hi,
I am trying to find average price of the shares in the
portfolio table.
I thought something like this should work...
SELECT symbol, ((sum(buyrate*quantity))/quantity) as
average
from portfolio group by symbol;
It does work, but wrong results. What is the correct
query?
Shantanu Oak
ype of server will I need to host such software.
(I apologize if it's out of topic)
Shantanu Oak
__
Do you Yahoo!?
Win a $20,000 Career Makeover at Yahoo! HotJobs
http://hotjobs.sweepstakes.yahoo.com/careermakeover
--
MySQL Gene