Is order important?

Question

Post reply

Is order important?

mhtanner

Mr or Mrs. 500

Points: 552
More actions
November 3, 2016 at 11:07 pm

#318618

Comments posted to this topic are about the item Is order important?
November 3, 2016 at 11:09 pm

This was removed by the editor as SPAM

Viewing 11 posts - 1 through 10 (of 10 total)

You must be logged in to reply to this topic. Login to reply

funbi SSCarpal Tunnel Points: 4992 More actions · Answer 1

I know it's not really the point of your question but

select count(*) from x where n % 6 = 0 and not n % 5=0

😀

DamianC SSCrazy Eights Points: 8015 More actions · Answer 2

Interesting question and just so happened to have read about this last week!

That's why I always use parenthesis

They also make queries easier to read

Especially with +, -, *, /, ... equations

- Damian

Revenant SSC-Forever Points: 42467 More actions · Answer 3

Thanks, Mike!

BTW, why there are snippets a and c when they are not mentioned in possible replies? Just curious.

Lokesh Vij SSChampion Points: 10836 More actions · Answer 4

Thanks Mike! A great way to reinforce the concepts 🙂

~ Lokesh Vij

Guidelines for quicker answers on T-SQL question[/url]
Guidelines for answers on Performance questions

Link to my Blog Post --> www.SQLPathy.com[/url]

Follow me @Twitter

MMartin1 One Orange Chip Points: 27768 More actions · Answer 5

I figured B, though I was struggling with D and was glad that the options were this or not this rather than figuring out the math on D 🙂

----------------------------------------------------

Gary Varga SSC Guru Points: 82166 More actions · Answer 6

DamianC (11/4/2016)
Interesting question and just so happened to have read about this last week!
That's why I always use parenthesis
They also make queries easier to read
Especially with +, -, *, /, ... equations

I was taught to use parenthesis not only for the compiler but also for the maintainer. Consistently not using parenthesis and relying on precedence leaves an ambiguity whereas someone who consistently uses them is also clear in their intent if they omit them.

Gaz

-- Stop your grinnin' and drop your linen...they're everywhere!!!

Koen Verbeeck SSC Guru Points: 259085 More actions · Answer 7

So much reading 😀

Excellent question, thanks.

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

TomThomson SSC Guru Points: 104773 More actions · Answer 8

Good question and explanation.

In my experience many developers and dbas are unaware of operator precedence for other than arithmetic or boolean operations - perhaps because they pay only lip service to set-oriented thinking. So it's nice to see a queston on precedence for set-oriented operators.

Tom

akljfhnlaflkj SSC Guru Points: 76202 More actions · Answer 9

akljfhnlaflkj

SSC Guru

Points: 76202

November 14, 2016 at 9:20 am

#1912302

Good to know about the precedence, thanks.