Bishal Chapagain Posted December 4, 2021 Share Posted December 4, 2021 I am using chrome browser (latest version) in windows 10. When i used NOT operator with SELECT it showed the following result.I hoped it would show syntac error. Whats wrong here ? Link to comment Share on other sites More sharing options...
Ingolme Posted December 4, 2021 Share Posted December 4, 2021 It casts the value of the CustomerName to a boolean 0 or 1 and then inverts that value using NOT. Strings are all equivalent to 0, so the opposite of that is 1. 1 Link to comment Share on other sites More sharing options...
niche Posted December 4, 2021 Share Posted December 4, 2021 (edited) Why did you use NOT instead of WHERE? Edited December 4, 2021 by niche Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now