sql function [message #289477] |
Sat, 22 December 2007 04:11  |
meys
Messages: 5 Registered: October 2007
|
Junior Member |
|
|
Hi All,
Is there any analytical function to do the below scenario in a simple way?
I have a table x with column -code with data's A, B, C, D
I want to get the sum of A and C and the sum of B and D through
select.
thanks in advance
|
|
|
|
|
Re: sql function [message #289480 is a reply to message #289477] |
Sat, 22 December 2007 04:53   |
meys
Messages: 5 Registered: October 2007
|
Junior Member |
|
|
Michel,
Thanks. I handled it through case , query got messed due
to improper group by.I found the defect.
meys
|
|
|
Re: sql function [message #289483 is a reply to message #289480] |
Sat, 22 December 2007 05:26  |
 |
Michel Cadot
Messages: 68733 Registered: March 2007 Location: Saint-Maur, France, https...
|
Senior Member Account Moderator |
|
|
Good, so now we don't know what was the problem and we don't know what is the solution.
Don't you think it would be helpful to post the whole thing?
Regards
Michel
|
|
|