Doubt with SQL syntax, but same result

irinel1996 · 09-06-2012, 02:09 PM

Hello,
I'm new in the forums.

Well, I'm learning SQL and I got a doubt when I do these two requests:

Code:

SELECT firstname,lastname FROM members WHERE money < 1350

Code:

SELECT firstname,lastname FROM members WHERE 1350 > money

Both works OK, but I'd like to know the difference between them.

Thank you!

_Aerospace_Eng_ · 09-07-2012, 10:41 AM

There is no difference. In both cases you are checking to see if 1350 is greater than money. It doesn't matter what order they are so long as you are using the correct comparison operators. The following however would be different

Code:

SELECT firstname,lastname FROM members WHERE money > 1350