Syed Ali Shah Rashdi
asked on
individual and sum
HI ,
I have table with currency and values now i want to select data for some currency individual and for all other sum .
Table structure.
Currency , Spot , Interest, Forward.
GBP , 1000 , 50 , 20
USD , 3000 , 60 , 10
CHF , 5000 , 60 , 30
AUD , 2010 , 40 , 33
CHF , 1000 , 10 , 10
Expected result of query .
Currecy , Spot , Interest , forward
GBP , 1000, 50 , 20
USD , 3000, 60 , 10
Other , 8010 , 110 , 73
Thanks .
I have table with currency and values now i want to select data for some currency individual and for all other sum .
Table structure.
Currency , Spot , Interest, Forward.
GBP , 1000 , 50 , 20
USD , 3000 , 60 , 10
CHF , 5000 , 60 , 30
AUD , 2010 , 40 , 33
CHF , 1000 , 10 , 10
Expected result of query .
Currecy , Spot , Interest , forward
GBP , 1000, 50 , 20
USD , 3000, 60 , 10
Other , 8010 , 110 , 73
Thanks .
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.