|
SQL how to manipulate it? -
December 13th, 2007
I entered this SQL command for a specific answer, I did get the answer but, it's too long how do I shorten it, if anyone knows it would be great...
Example Code entered:
SELECT ENAME, JOB, SAL, COMM, SAL+COMM, 100*(COMM/(SAL+COMM))FROM EMP WHERE COMM IS NOT NULL;
Result for the "100*(COMM/(SAL+COMM))" =52.8301886792452830188679245283018867925
How do I shorten this to maybe = 52.8301.
Please help, thank you...
|