How to read the select statement to understand the result
-2
votes
1
answer
43
views
I am convinced that it is a very basic question, but I still have to ask it, making queries on the Oracle HR schema I notice that the result of these two queries is different:
Expected result:
I would like to know why this happens, when using the parentheses it gives me the result I want, while if I do not use the parentheses it gives me another record (Pat Fay) that does not make sense, how should I read this sentence to understand these outputs, thank you very much .


Asked by miguel ramires
(169 rep)
Dec 18, 2020, 03:34 AM
Last activity: Dec 18, 2020, 04:02 AM
Last activity: Dec 18, 2020, 04:02 AM