In SQL, how to multiply data of two columns for third column

a    b

2    4

2    5

2    6

Select a, b, (a*b) as c from table

  

a    b   c

2    4   8

2    5   10

2    6   12