Post reply

Unusual use of the WHERE clause

  • July 6, 2020 at 11:19 pm

    This was removed by the editor as SPAM

  • July 7, 2020 at 5:54 am

    #3767917

    When you compare it can return either true or false. If it is true, then the row is returned otherwise - not. "ColumnName" returns some numeric value expression does as well. So at then end you'll have 2 numbers compared (surely if these 2 are numeric ones) and it doesn't matter was that column or expression.

    1 < 3 - true

    3 < 1 - false

    1 < 1 - false

    100 = 100 - true

  • July 7, 2020 at 11:16 am

    This was removed by the editor as SPAM

Viewing 3 posts - 16 through 17 (of 17 total)

You must be logged in to reply to this topic. Login to reply