In the lecture, we go ahead and look at weight loss in PostgreSQL.
So in PostgreSQL we have what is called a react clause and where clause is used to filter records.
And this helps us to extract only the records that meet a specified conditions in a PostgreSQL database.
So let me go ahead and see how to select something.
I'll go ahead and say select all from students.
Then I'm going to add a Where clause and we are close to this.
Maybe we estimate ID is equal to DS, or where the email is equal to DS, or where a first name or last
name is equal to this.
So I'll go ahead and see where the students underscore ID is equal to four and put a semicolon at the
end.
And if I hit enter I'll get this.
So this is what I have.
Now if I go right in here and do that on the pgadmin, I'll go right here and select all from students.
And then I'll go ahead and remove the semicolon.
And then I'll go ahead and add a where the student ID or the first name or the last name.
Then go ahead and see where the first underscore name is equal to beta, and put a semicolon at the
end.
And let's go ahead and execute this.
And this is what we have.
And you see that Peter Jude.
And this is what we have.
So the request helps you to specify a condition.
And you actually want to filter these out.
And that is where we are process very very important.
All right.
And what do we do right inside Pgadmin.
You can actually do that right in here under the SQL shell.
So I believe the Where clause is very easy going to practice that.
And we're going to use more of that and some lectures to come.
And I believe that we have us a lot.
So practice with that.
And if you have any question or had I use the question and answer section and I'm going to get back
to you as soon as possible.
Thank you so much.
And I'm going to see you in the next video lecture.