Again Doubt on Query pls help (Doubt not cleared)

[Veerabhadrarao Narra]

i have to write one query

        Division        Units        Year
             a           200         2004
             a           300         2005
             b           500         2004
             b           800         2005
             b           900         2006
             c           100         2004

>From these values i want to retreive as like this

        Division        Units        Year
        a                200          2004
        a                100          2005
        b                500          2004
        b                300          2005
        b                100          2006
        c                100          2004

Group By division names and year with difference.
Means difference of the Units values by year can u give me this query.




-- 
veerabhadrarao narra,
+91-988-556-5556
I-ONE TECH LABS Pvt Ltd.
HYDERABAD, INDIA


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]