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]
