SQL Help?

[sinkesnnj]

So today on collage i had an sql query test where on of the questions was if the following two are equal:

 

1)  a OR b*c>=d

2)  a OR (b*c>=d)

 

Now i answered yes, but some guys from my class made a point where in the first case it would do it like this (a OR b*c) >= d and the two above were not equal. Was i right or were they right?

[Toxicable]

So today on collage i had an sql query test where on of the questions was if the following two are equal:

 

1)  a OR b*c>=d

2)  a OR (b*c>=d)

 

Now i answered yes, but some guys from my class made a point where in the first case it would do it like this (a OR b*c) >= d and the two above were not equal. Was i right or were they right?

Im not sure about SQL but from what I know in Python they should return equally 

I'd suggest you look up the order in which logical operators are evaluated.

 

EG in Python Compairison operators is higher on the order of operation than Boolean Conditionals

[MrSuperb]

looking at operator precedence of sql, I would say they are equal.

highest
*
>=
OR
lowest

[sinkesnnj]

looking at operator precedence of sql, I would say they are equal.

highest

*

>=

OR

lowest

Thank you very much good sir, god bless you!

[vorticalbox]

So today on collage i had an sql query test where on of the questions was if the following two are equal:

 

1)  a OR b*c>=d

2)  a OR (b*c>=d)

 

Now i answered yes, but some guys from my class made a point where in the first case it would do it like this (a OR b*c) >= d and the two above were not equal. Was i right or were they right?

assuming a, b, c and d are the same values for both they would be the same