Penny Arcade Forums› Help / Advice Forum
The new forums will be named Coin Return (based on the most recent vote)! You can check on the status and timeline of the transition to the new forums here.
The Guiding Principles and New Rules document is now in effect.

What will be the result of the query below?

sonal78sonal78 Registered User new member
in Help / Advice Forum
SELECT * FROM runners WHERE id NOT IN (SELECT winner_id FROM races)

Posts

  • SixSix Caches Tweets in the mainframe cyberhex Registered User regular
    edited June 2016
    It will select the items in the runners table whose winner_id does not appear in the races table. Presumably it will tell you all the runners who have not won a race.

    Six on
    can you feel the struggle within?
  • schussschuss Registered User regular
    Tough to tell without knowing the table/database structure.

Sign In or Register to comment.
Penny Arcade Forums› Help / Advice Forum