Applying condition on parameters in SQL select query

Question

I am calculating a column based on existing tables column, but I don't know how to do that.

To explain my problem, let's say I have a table which has two columns A and B, both are int. What I am doing right now is

Select A,B (A-B)as C from Table

The check I want to apply is

if C is less then Zero it should show Zero. rather then a negative value.

What is the way to do this in SQL?

Mark Rotteveel · Accepted Answer · 2022-09-29 16:29:54Z

1

Select A,B,
CASE WHEN (A-B) < 0 THEN 0
ELSE (A-B)
END as C 
from Table

edited Sep 29, 2022 at 16:29

Mark Rotteveel

110k241 gold badges160 silver badges233 bronze badges

answered Jan 2, 2013 at 5:43

Raj

10.9k2 gold badges47 silver badges53 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Vishal Suthar · Accepted Answer · 2013-01-02 05:52:44Z

1

You have to Use CASE (Transact-SQL)

This is what you want:

select A,B,
case when(A-B) < 0 then 0 else (A-B) end as c 
from Table

Demo: SQL Fiddle

edited Jan 2, 2013 at 5:52

answered Jan 2, 2013 at 5:45

Vishal Suthar

17.2k4 gold badges64 silver badges109 bronze badges

Comments

Rikesh · Accepted Answer · 2013-01-02 06:05:59Z

1

Try this,

  Select A,B ,case when(A-B)< 0 then 0 else (A-B) end as C from Table;

edited Jan 2, 2013 at 6:05

Rikesh

26.5k14 gold badges82 silver badges90 bronze badges

answered Jan 2, 2013 at 5:43

Nipun Jain

6014 silver badges6 bronze badges

Comments

Vishal Suthar · Accepted Answer · 2013-01-02 10:14:02Z

-1

    try this

    select a,b,(a-b < 0 , 0 , a-b) as c from <table>
    // if then usage in mysql

    SELECT a,b,if(a-b < 0;0;a-b) as c FROM <table>
    // if then usage in sql

    // ie. if a-b is less than 0 then 0 else a-b

edited Jan 2, 2013 at 10:14

Vishal Suthar

17.2k4 gold badges64 silver badges109 bronze badges

answered Jan 2, 2013 at 5:45

Kapil gopinath

1,0431 gold badge8 silver badges19 bronze badges

1 Comment

Josh Darnell Over a year ago

FYI - the question is tagged with SQL Server, and specifically Transact-SQL. That uses CASE statements, rather than if-then.

Collectives™ on Stack Overflow

Applying condition on parameters in SQL select query

4 Answers 4

Comments

Demo: SQL Fiddle

Comments

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

Demo: SQL Fiddle

Comments

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related