Different versions differnet results

; _ 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]

First In First Out stock calculation query

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]

guess_table utility

to 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]

correcting the booklet

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

average in Group By

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

SQL and Yahoo IM

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 General Mailing List For list