Question: how to subtract one column from another column in sql?
Answer: You simply subtract both columns and display it as column like below query.
SELECT col1,col2,(col1-col2) as col3 FROM table;
This will display the difference in third column.