SQL Multiply Columns in where statment

Question

I am newer to sql I have a table:

MyTable

column1  column2
-----------------
5        3 
2        2

I need a query that will give me back all of the rows where column1 * column2 > 10?

Answer 1

SELECT * FROM MyTable WHERE (column1 * column2) > 10;
You can specify as many columns as you want (within reason) and apply math to them in the WHERE clause.

Answer 2

select column1, column2
from MyTable
where column1 * column2 > 10

Answer 3

If I understand you correctly you can do this in the where clause ie select * from mytable where column1*column2 > 10

Answer 4

select * from MyTable where Column1 * Column2 > 10