i have to write one query

        Division        Units        Year
        ameerpet         200         2004
        ameerpet         300         2005
        ameerpet         500         2006

>From these values i want to retreive as like this

        Division        Units        Year
        ameerpet         200          2004
        ameerpet         100          2005
        ameerpet         200          2006
Means difference of the Units values by year can u give me this query.

-- 
veerabhadrarao narra,


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


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

Reply via email to