dannayakrahul (2/21/2014)
I just got struck while building a query with sql in ms acess
I want to minus two rows in sql with ID as 2 and 3 and want the output of the conversion values in a new column
COS_IDCUR_DATECUR_RATEVCOS_NAMEVCOS_QUOTA_OLDconversion
116.07.2013 7,86MCR_P_OLD 100% 0
216.07.2013 1,31ST_P_OLD 100% 381,888
316.07.2013 1OFR_P_NEW 100% 230
116.07.2013 7,86MCR_P_OLD 100% 0
216.07.20131,31ST_P_OLD100%54,6
316.07.20131OFR_P_NEW100%14
116.07.20137,86MCR_P_OLD100%0
216.07.20131,31ST_P_OLD100%51,285
316.07.20131OFR_P_NEW100%15,75
Now i have the table above and i want to minus the conversion values of(conversion(2 and 3) and want to display it in new column as i have 1,2,3 repeated values in COS_ID i want to the output like
COS_ID Conversion
2and3 381,888- 230 and the value should be in new column
Waiting for some response ASAP
Thanking you in advance
Please say me is it possible to do i sql or not as iam not that good in sql need your Suggestion too