Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 2 of 2
  1. #1
    New to the CF scene
    Join Date
    Sep 2012
    Location
    Canary Islands, Spain
    Posts
    1
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Question Doubt with SQL syntax, but same result

    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!

  • #2
    Supreme Master coder! _Aerospace_Eng_'s Avatar
    Join Date
    Dec 2004
    Location
    In a place far, far away...
    Posts
    19,291
    Thanks
    2
    Thanked 1,043 Times in 1,019 Posts
    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
    ||||If you are getting paid to do a job, don't ask for help on it!||||


  •  

    Tags for this Thread

    Posting Permissions

    • You may not post new threads
    • You may not post replies
    • You may not post attachments
    • You may not edit your posts
    •