I have a colume with letters G,N.Y,and R I'm using the "count " function to list how many of each are in the colume....SELECT COUNT(CHANGECODE)
FROM datafare
WHERE CHANGECODE = 'S'
then I have to display the diffrence between lets say "S" - "R" ="X" the result I need.
how do you display the diffrence ?

Originally posted by Netstarhost
I have a colume with letters G,N.Y,and R I'm using the "count " function to list how many of each are in the colume....SELECT COUNT(CHANGECODE)
FROM datafare
WHERE CHANGECODE = 'S'
then I have to display the diffrence between lets say "S" - "R" ="X" the result I need.
how do you display the diffrence ?

Do two selects and substract the results?