Is there a way, in SQL, to accomplish a comparison that says x is larger y than but also smaller than z, like:
Code: Select all
... WHERE COLUMN < 11 AND COLUMN > 0; #column is x, 11 is y, and 0 is z.
Thanks for reading.
Moderator: General Moderators
Code: Select all
... WHERE COLUMN < 11 AND COLUMN > 0; #column is x, 11 is y, and 0 is z.