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