Original subtitles

0 Except, operator, is you used to written all rows in the first select statement and then it removes all 1

the rows that are present in the second select statement. 2

So basically, if you have one table, it will first take out all the rows that you wanted from that 3

table. 4

And after that, it will remove the rows that are present in the select statement of the second table. 5

So basically it is combining the two tables. 6

In this sense, it is removing the parts of table 2 from the table 1, the syntax. 7

for this goes like this. 8

You mentioned the first select statement, which is select the expressions from table one. 9

You can specify where condition if you want to, then we will write 10

the keyword, except after this, you'll write the second select statement, which can work on the second 11

table. 12

Important thing to note here is the expression 1 13

expression 2 that you write in the first table should be same as the expressions in the second table 14

that you're selecting. 15

Let us look at example, how this is used, for example, if you want to find out the customer IDs from 16

the sales table for which you do not have the customer details in your customer table, we will use 17

the except keyword here will first select customer id from the sales table. 18

This will give us all the customer I.D. from this table. 19

Then we will write except those customer IDs for which we have data in the customer table so those will 20

be removed. 21

Only those customer I.D. will remain for which we do not have the data in customer table 22

Let us go and write this. 23

So let's start writing select customer id 24

from the first table, sales table 25

except 26

customer Ids from customer table. 27

And let us order them by customer ids 28

So you can see when I run this query, in the ResultSet. 29

10315 is present because it is present in the sales table and not present in the customer 30

table, 10375 is not present because it is present in both the tables. 31

One zero four zero is not present because it is not present in the sales table itself. 32

So all the customer ids for which you do not have data in the customer table are here with you. 33

This is the except operator, next we will look at the union operator.