use expressions in the WHERE Clause.

Bageshkumarbagi
Posted by Bageshkumarbagi under Sql Server category on | Points: 40 | Views : 742
Hi,

Here i have written a sql how to use expressions in the WHERE Clause.

SELECT name, salary, salary*1.5 AS new_salary FROM emp
WHERE salary*1.5 >= 25000 and dept='MCA'


********Output*********

name salary new_salary
----------- ---------- ----------------
Bagesh 30000 45000
Rajesh 25000 37500
Ramesh 32000 48000

Comments or Responses

Login to post response