Precedence in math

  • Comments posted to this topic are about the item Precedence in math

    If everything seems to be going well, you have obviously overlooked something.


    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]

  • easy one to start the day .. the brackets made it easy ..

    ~ demonfox
    Wondering what I would do next , when I am done with this one :ermm:

  • Easy one. Revision of basics 🙂

    Thanks Ron!

    ~ Lokesh Vij

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

    Link to my Blog Post -->[/url]

    Follow me @Twitter

  • 🙂 (do i have to say more...?)

    ww; Raghu
    The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.

  • I completely disagree.

    Only for the sake of creating discord, malcontent, and to be argumentative because there is nothing in the question to whine about otherwise.

    Jason...AKA CirqueDeSQLeil
    I have given a name to my pain...MCM SQL Server, MVP
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • Easy 🙂 Easy:)

  • Very Easy. 🙂

  • Very simple one.. You could have made it bit complex by adding few expressions of same precedence or different level without parenthesis. That will help us to think more..

    Thanks for the point.

    Desire to learn new things..

  • Actually, I liked the linked article very much especially last 3 paragraphs. (not even close for being an average on math, but my common-sense on this subject occasionally helps me. 😉 )

    ww; Raghu
    The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.

  • Nice back to basics question. Thanks!

  • Thanks for the question Ron. Easy point today and without the need for coffee 🙂

    -------------------------------Posting Data Etiquette - Jeff Moden [/url]Smart way to ask a questionThere are naive questions, tedious questions, ill-phrased questions, questions put after inadequate self-criticism. But every question is a cry to understand (the world). There is no such thing as a dumb question. ― Carl Sagan I would never join a club that would allow me as a member - Groucho Marx

  • If this is an easy starter for a series of questions that gradually builds up, then it's sort of okay - though probably TOO easy.

    As a stand alone question, I am not excited about it. The use of parentheses in all the queries means that there is no ambiguity anywhere, even for those who don't know the rest of the arithmetic precedence rules (and I would hope that almost everyone would get the question right even if there were no parentheses used in some of the queries).

    Also, why use a blog post as the only reference, when a 5 second Google search would have given you this Books Online link?

    Hugo Kornelis, SQL Server/Data Platform MVP (2006-2016)
    Visit my SQL Server blog:
    SQL Server Execution Plan Reference:

  • While it does appear to just test basic maths, I'd argue that doing an example without brackets is just annoying, and I'd be pretty displeased if debugging someone's SQL who had not bothered to put in some brackets for anything except basic addition / subtraction. Still I suppose something could have been done to spice it up, but I guess I'm not coming up with anything *shrugs*

  • This was removed by the editor as SPAM

  • Thanks for easy one. Giving us the parens even made it easier.

Viewing 15 posts - 1 through 15 (of 59 total)

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