sql - Movie and Year exist in one query but not both -
I have two questions, first gives a film and a year, in which there are such movies, more than two actors and the other The query displays movies that have won more than two awards
So I want to write a question that I will get in a movie and the year in which one query is but not both. How can I do this?
Syntax is in Oracle
We can do it MINUS
The first set rows that are present in Table 1 alone
There are the second set rows that are only available on table 2
Select Table 1 again from the table * 2 Select Union from * Select Table 2 min from * to Table 1
Comments
Post a Comment