SQL comparison operators

are these two statements the same?

query 1: WHERE salary > 999;

query 2: WHERE salary >= 1000;

I thought they were, but apparently according to my peers they are n开发者_运维知识库ot (Though they have failed to explain why).

That's not necessarily the same. If you're storing doubles, when you do:

WHERE salary >= 1000;

you're not taking in count all values that are between 999 and 1000 (eg. 999.50)

Otherwise, if you're working with integers, that's true, not only in programming, but also in maths.

n > k <=> n >= k+1

The two queries will give the same results, if salary is an integral type. But if salary is some real type, then the results will be different.

This is entirely dependant on the datatype of salary.

If salary is an INT or a BIGINT then yes they will yield the same results.

If salary is pretty much any other datatype, the first once will return results for 999.9, but the second one won't.