Post reply

Union and Union All

  • July 9, 2012 at 5:14 am

    #1510262

    Hi Duncan Pryde,

    for your question

    #Query1 Answer is only A

    #Query2 Answer is A,A

  • July 9, 2012 at 5:39 am

    #1510271

    Duncan Pryde (7/9/2012)

    Not a bad question, and got me thinking about other possible questions, so here goes - how many rows are returned in the two following cases?

    -- Query 1

    SELECT 'A'

    UNION ALL

    SELECT 'A'

    UNION

    SELECT 'A'

    -- Query 2

    SELECT 'A'

    UNION

    SELECT 'A'

    UNION ALL

    SELECT 'A'

    Try to guess first, then use MS to verify. 😀

    Knowing how sometimes several consecutive (or semi-consecutive) QOTDs have followed a theme, I can't help but wonder if Mr. Pryde just ruined someone's forthcoming submission.

  • July 9, 2012 at 5:40 am

    #1510273

    Nice, simple, but useful question. THanks!

    I almost answered the question as I first misread it:

    SELECT 'A'

    UNION ALL

    (SELECT 'B'

    UNION

    SELECT 'A')

    Which gives the A,A,B I almost clicked on. I have my tea now, so everything is all right. 😉

    [font="Verdana"]Please don't go. The drones need you. They look up to you.[/font]
    Connect to me on LinkedIn

  • July 9, 2012 at 6:10 am

    #1510287

    Bob Razumich (7/9/2012)

    Knowing how sometimes several consecutive (or semi-consecutive) QOTDs have followed a theme, I can't help but wonder if Mr. Pryde just ruined someone's forthcoming submission.

    It did occur to me (after I posted of course), but normally, people put "1" in the title if it's the first part of a series, so fingers crossed.

  • July 9, 2012 at 6:49 am

    #1510305

    I thought it looked familiar!

    http://www.sqlservercentral.com/Questions/Tags/UNION/UNION/

  • July 9, 2012 at 6:57 am

    #1510310

    Nice easy question. Great for a Monday morning to get some brain juices going. :doze:


    Everything is awesome!

  • July 9, 2012 at 7:07 am

    #1510317

    Toreador (7/9/2012)

    I thought it looked familiar!

    http://www.sqlservercentral.com/Questions/Tags/UNION/UNION/

    I'm working backwards through the QODs at the moment after a bit of a gap, so hadn't seen the March 8th question. However, reading the discussion for the question it shows how important order of UNIONs and the addition or omission of parentheses are!

  • July 9, 2012 at 8:25 am

    #1510364

    Nice and easy back-to-basics question. Thank you, Sanjeewan.

    "El" Jerry.

    "El" Jerry.

    "A watt of Ottawa" - Gerardo Galvan

    To better understand your help request, please follow these best practices.[/url]

  • July 9, 2012 at 8:29 am

    #1510366

    thanks for the question - cheers

  • July 9, 2012 at 12:35 pm

    #1510512

    Toreador (7/9/2012)

    I thought it looked familiar!

    http://www.sqlservercentral.com/Questions/Tags/UNION/UNION/

    Except that the earlier QotD was more challenging for me (and I got it wrong because I thought UNION took precedence over UNION ALL) than this one (which had a set of parentheses forcing precedence).

  • July 9, 2012 at 2:15 pm

    #1510573

    Nice easy question but the parenthenses are meaningless in this question they have no impact on the results.

  • July 9, 2012 at 9:42 pm

    #1510667

    Nice and easy ...

    Thanks

  • July 10, 2012 at 2:06 am

    #1510724

    Thanks for this question. After last wek it is just whats needed.

  • July 10, 2012 at 1:33 pm

    #1511170

    mike.broniszewski (7/9/2012)

    Nice easy question but the parenthenses are meaningless in this question they have no impact on the results.

    Neither does the UNION ALL.

  • July 11, 2012 at 12:02 am

    #1511334

    Nice one thank you

    Iulian

Viewing 15 posts - 16 through 30 (of 37 total)

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