GOBIN Posted May 23, 2021 Share Posted May 23, 2021 hi , i just started learning SQL on w3 school and i have a question : in the SQL HAVING statement course last example i tried to write the code then checked the example but it didn't work this my code and this is the example thnk you . Link to comment Share on other sites More sharing options...
niche Posted May 24, 2021 Share Posted May 24, 2021 It’s not clear to me whether your second example worked. It looks like it did. Did it? If not, what were you expecting? Link to comment Share on other sites More sharing options...
GOBIN Posted May 25, 2021 Author Share Posted May 25, 2021 the second exemple is not mine , it's on the tutorial , mine is the first one and it didn't work Link to comment Share on other sites More sharing options...
GOBIN Posted May 25, 2021 Author Share Posted May 25, 2021 13 hours ago, niche said: It’s not clear to me whether your second example worked. It looks like it did. Did it? If not, what were you expecting? the second exemple is not mine , it's on the tutorial , mine is the first one and it didn't work Link to comment Share on other sites More sharing options...
niche Posted May 25, 2021 Share Posted May 25, 2021 (edited) So, why not do the join? EDIT: I’d do your OR differently: WHERE this = that AND ln = OR this = that AND ln = Edited May 25, 2021 by niche Link to comment Share on other sites More sharing options...
GOBIN Posted May 25, 2021 Author Share Posted May 25, 2021 2 hours ago, niche said: So, why not do the join? EDIT: I’d do your OR differently: WHERE this = that AND ln = OR this = that AND ln = i'll try it , thank you 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