Get answers from your peers along with millions of IT pros who visit Spiceworks.
Join Now

I have an issue with today's Test your IT IQ question.  The way the question was phrased was vague, and can be interpreted to mean that the results from two queries should return unique and distinct results.  That was the interpretation I had, and chose INTERSECT as my answer.  Apparently, the answer is UNION.  UNION returns unique rows and eliminate duplicates from the two queries, provided that there are the same number of columns.  Am I wrong to assume that the question was too vague for me to choose either UNION or INTERSECT?


Learn PowerShell with this beginner How-to
A folder that contains sensitive data should not be getting new files without your knowledge. To stay informed about new files in importa...
Aug 15, 2018 at 15:00 UTC
On the Air
On The Air: CenturyLink - Get Off My WLAN! Wireless Network Security

5 Replies

· · ·
L0ST_0NE
Datil
OP
L0ST_0NE

Questions are random and everyone (for the most part) get different questions.

If you see issues with questions you can flag them.

2
· · ·
JFEB
Thai Pepper
OP
JFEB

I'm pretty sure there's something in the question you can click on if you have a problem with the question.

1
· · ·
deanmoncaster
Cayenne
OP
deanmoncaster

You should post this question on the test your IQ question thread.

0
· · ·
Ross42.
Mace
OP
Ross42.

You can flag them, we have no idea which question you're referring to. I've gotten a couple questions removed by flagging them, and others they decided could stay.

0
· · ·
Sean (Spiceworks)
OP
Sean (Spiceworks)

If you go to Account Settings using the nav under your avatar (top right in the navigation), then Daily Challenge, you'll see a section called "Previous Challenges". If you click on the Explanation for the one you're referring to, you can both get to the conversation about that particular topic but also the report feature for it, as well.

0
Oops, something's wrong below.