Welcome to TDBSoverflow, Our class's own StackOverflow. Our rules:
  1. Use only meaningful and self-explanatory titles
  2. Tag your questions with meaningful keywords
  3. Use upvotes and downvotes to rate the answers
  4. When you receive a satisfying answer - Click the "V" button
Remember: you may get up to 5 bonus points to your final grade!

Using INTERSECT and EXCEPT in the test

+5 votes
45 views

We were told that 'INTERSECT' and 'EXCEPT' are missing from MySQL

(And saw an example of using 'EXISTS' and 'NOT EXIST' to replace them)

Are we allowed to use them in the test? 

Thanks

asked Feb 3, 2018 by Assaf (31,090 points)
+1:
Different reason but same question - can we use LIMIT in the exam?
We weren't allowed to use it in H.W #1.
+ Same question about FULL OUTER JOIN

1 Answer

+1 vote
 
Best answer
Yes you can use everything taught by Tova in the SQL lectures,

 unless specifically stated otherwise in the question
answered Feb 5, 2018 by Amit (27,910 points)
selected Feb 5, 2018 by Assaf
...