PostgreSQL NOT IN

Faruk Erdem

11 months ago

In today’s article, we will be explaining the Use of NOT IN to fetch data that does not contain the specified values.

Let’s explain through examples.

Let’s have a ogrenci table and ask it to return values other than the values specified in our ogrenci table.

First, let’s see our student table.

Let’s list the students who do not have a final grade of 71 and 60.

SELECT*FROM  ogrenci WHERE final NOT IN ('71','60') ;

1	SELECT*FROM ogrenci WHERE final NOT IN ('71','60') ;

In our example above, the final grade returned values that were not 71 and 60.