Add filter on column which subtract to columns

Question

i have long store procedure in whcih i want Add filter on this Column

select (PaymentAmount-PaymentPosted) as Unapplied, BalancDue from ERAMaster
 where Unapplied = 22

but i run the query they give me error invalid column name. any one tell me the write way to Add filter on Unapplied Column

it should be `where PaymentAmount-PaymentPosted = 22`. There is no way to use column alias in WHERE clause. — King King, Nov 13 '17 at 06:20

score 1 · Answer 1 · answered Nov 13 '17 at 06:20

1

It should be like this:

select (PaymentAmount-PaymentPosted) as Unapplied, BalancDue from ERAMaster
 where (PaymentAmount-PaymentPosted) = 22

'Unapplied' is not a column name it is only alias.

answered Nov 13 '17 at 06:20

Anagha

score 1 · Accepted Answer · answered Nov 13 '17 at 06:26

1

You can do it like below :

select * from 
(
    select (PaymentAmount-PaymentPosted) as Unapplied, BalancDue from ERAMaster
) as T where Unapplied = 22

Or like this :

select (PaymentAmount-PaymentPosted) as Unapplied, BalancDue from ERAMaster
where PaymentAmount-PaymentPosted = 22

answered Nov 13 '17 at 06:26

Md. Suman Kabir

Please read [This](https://stackoverflow.com/a/47002068/5695953) to get more useful information. – Md. Suman Kabir Nov 13 '17 at 06:33

2 Answers2