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

Popular posts from this blog

winforms - C# Form - Property Change -

javascript - amcharts makechart not working -

java - Algorithm negotiation fail SSH in Jenkins -