Random unions

Question

Random unions

Steve Jones - SSC Editor

SSC Guru

Points: 737475
More actions
October 22, 2014 at 9:28 pm

#74262

Comments posted to this topic are about the item Random unions
October 22, 2014 at 11:01 pm

This was removed by the editor as SPAM

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

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

Koen Verbeeck SSC Guru Points: 259155 More actions · Answer 1

Nice question, thanks.

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

Michael Riemer SSCertifiable Points: 5190 More actions · Answer 2

Great simple question... Was looking for the catch, and very glad there wasn't one!

Raghavendra Mudugal SSChampion Points: 10658 More actions · Answer 3

Thank you for the post, Steve, good one.

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

Raghavendra Mudugal SSChampion Points: 10658 More actions · Answer 4

Michael Riemer (10/23/2014)
,,Was looking for the catch...!

If i had 1 rupee everytime i did or said that, i would have brought a 1tb PHD....:-D

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

bholthuijsen Valued Member Points: 63 More actions · Answer 5

Nice question!

I was surprised that the final RAND() also returns a constant value after a previous call with a seed. It's in the Remarks in BOL, so I guess it's by design.

Ed Wagner SSC Guru Points: 287026 More actions · Answer 6

A nice, basic question. Thanks, Steve.

Tally Tables - Performance Personified
String Splitting with True Performance
Best practices on how to ask questions

TomThomson SSC Guru Points: 104773 More actions · Answer 7

Amusing question; the use of RAND is an interesting distraction for a question that is really about UNION ALL and nothing else.

Tom

SqlMel SSCrazy Points: 2901 More actions · Answer 8

Thanks for the easy points :hehe:

---------------
Mel.

Brian.Klinect Mr or Mrs. 500 Points: 592 More actions · Answer 9

TomThomson (10/23/2014)
Amusing question; the use of RAND is an interesting distraction for a question that is really about UNION ALL and nothing else.

I agree. I focused on what the RAND would return, and completely missed it was UNION ALL, and not UNION.

Xavon SSCrazy Points: 2280 More actions · Answer 10

Michael Riemer (10/23/2014)
Great simple question... Was looking for the catch, and very glad there wasn't one!

The catch is that almost the same question was asked on 2014/09/29, except that one used UNION instead of UNION ALL...

akljfhnlaflkj SSC Guru Points: 76202 More actions · Answer 11

Good reminder about the ALL part of UNION. I've got myself caught up when I wanted all rows and forgot to use the ALL. My duplicates, which I wanted, disappeared. Silly me.

stephen.long.1 SSCrazy Points: 2582 More actions · Answer 12

Nice question, Steve. I thought that the values in the third column would be different in each row, but I forgot that the seeds set the sequence for subsequent calls. Fortunately, I caught the ALLs and realized that the values returned by RAND didn't matter; all three rows would be returned whether they were identical or not.

ZZartin SSC-Dedicated Points: 30921 More actions · Answer 13

Nice question, it's not trivia and it doesn't rely on intentionally misleading syntax.

Random unions

Cookies on SQLServerCentral