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.