MySQL ODBC Connector - I NEED QUERY on Difference between values (Any Group Functions are

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

I NEED QUERY on Difference between values (Any Group Functions are

Veerabhadrarao Narra

2006-01-28, 7:23 am

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/mysql? unsub...sie.nctu.edu.tw

Sponsored Links