The Number Subquery

Question

Viewing 4 posts - 1 through 3 (of 3 total)

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

Matthias.Meyer SSC-Addicted Points: 400 More actions · Answer 1

SSC-Addicted

Points: 400

May 10, 2021 at 7:42 am

I think the correct answer should be 1, 10, 14.

GaryV Hall of Fame Points: 3307 More actions · Answer 2

There's no value 5 in the table, so that meets the NOT EXISTS condition for value 6. That's why 6 is returned, in addition to 1, 10 and 14.

Matthias.Meyer SSC-Addicted Points: 400 More actions · Answer 3

You're right, it seems I missed the missing number 5.