PostgreSQL - SELECT WHERE

Introduction

In this tutorial, we want to select data from a table that satisfy a certain condition. In order to do this, we use the SELECT Statement with the WHERE Clause.

We have already created the table student with the following data:

Example 1

We want to select all columns where the gender is 'female'.

In order to do this, we execute the following SQL statement:

SELECT * FROM student
WHERE gender = 'female';

The following selection is returned:

Example 2

We want to select all columns where the studentid is 3.

In order to do this, we execute the following SQL statement:

SELECT * FROM student
WHERE studentid = 3;

The following selection is returned:

Conclusion

Congratulations! Now you are one step closer to become an AI Expert. You have seen that it is very easy to select data from a table that satisfy a certain condition. We can simply use the SELECT Statement with the WHERE Clause. Try it yourself!