All language subtitles for 10. Except

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.