Multiple expressions in mysql IF condition

Question

I need to compare some values from table, i.e. if less, greater and equal...

My query looks like:

  SELECT `t1`.`K1`
  IF (Sum(`t1`.`K1`) > Sum(`t2`.`K1`), 'Greater', 'Less') AS State
  FROM `t1`
  INNER JOIN `t2` ON `t1`.`Code` = `t2`.`Code`
  GROUP BY `t1`.`K1`

How to implement condition if values are equal?

Just btw, you are missing , after SELECT t1.K1...

Legionar
– Legionar

2013-11-22 11:14:49 +00:00
Commented Nov 22, 2013 at 11:14 — Legionar
– Legionar, Commented Nov 22, 2013 at 11:14

juergen d · Accepted Answer · 2013-11-22 11:11:56Z

3

SELECT `t1`.`K1`,
       case when Sum(`t1`.`K1`) = Sum(`t2`.`K1`) then 'Equal'
            when Sum(`t1`.`K1`) > Sum(`t2`.`K1`) then 'Greater'
            else 'Less'
       end AS State
FROM `t1`
INNER JOIN `t2` ON `t1`.`Code` = `t2`.`Code`
GROUP BY `t1`.`K1`

answered Nov 22, 2013 at 11:11

juergen d

205k40 gold badges303 silver badges376 bronze badges

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

Comments

Legionar · Accepted Answer · 2013-11-22 11:12:42Z

1

SELECT `t1`.`K1`,
IF (Sum(`t1`.`K1`) = Sum(`t2`.`K1`), 'Equal', IF (Sum(`t1`.`K1`) > Sum(`t2`.`K1`), 'Greater', 'Less')) AS State
FROM `t1`
INNER JOIN `t2` ON `t1`.`Code` = `t2`.`Code`
GROUP BY `t1`.`K1`

answered Nov 22, 2013 at 11:12

Legionar

7,5993 gold badges45 silver badges71 bronze badges

Collectives™ on Stack Overflow

Multiple expressions in mysql IF condition

2 Answers 2

Comments

Comments

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Related