sql max(val1,val2)? [duplicate]

Question

is there some way to determine the max value out of two values in SQL?

I use the mod function:

MOD(cnt, cnt/100)

This yields a division by 0 error when cnt is smaller than 100. I therefore would like something like this:

MOD(cnt, MAX(cnt/100, 1))

ScaisEdge · Accepted Answer · 2016-12-29 17:39:54Z

2

You can use greatest

SELECT greatest(a, b, c) FROM your_table;

answered Dec 29, 2016 at 17:39

ScaisEdge

134k10 gold badges98 silver badges111 bronze badges

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

1 Answer 1