WEBVTT

00:07.340 --> 00:11.960
In the lecture, we go ahead and look at weight loss in PostgreSQL.

00:12.020 --> 00:17.810
So in PostgreSQL we have what is called a react clause and where clause is used to filter records.

00:17.810 --> 00:27.110
And this helps us to extract only the records that meet a specified conditions in a PostgreSQL database.

00:27.110 --> 00:30.080
So let me go ahead and see how to select something.

00:30.110 --> 00:39.200
I'll go ahead and say select all from students.

00:39.320 --> 00:43.130
Then I'm going to add a Where clause and we are close to this.

00:43.160 --> 00:48.440
Maybe we estimate ID is equal to DS, or where the email is equal to DS, or where a first name or last

00:48.470 --> 00:49.490
name is equal to this.

00:49.490 --> 01:01.940
So I'll go ahead and see where the students underscore ID is equal to four and put a semicolon at the

01:01.970 --> 01:02.360
end.

01:02.360 --> 01:04.610
And if I hit enter I'll get this.

01:04.610 --> 01:06.740
So this is what I have.

01:08.090 --> 01:16.580
Now if I go right in here and do that on the pgadmin, I'll go right here and select all from students.

01:16.580 --> 01:20.580
And then I'll go ahead and remove the semicolon.

01:20.580 --> 01:29.130
And then I'll go ahead and add a where the student ID or the first name or the last name.

01:29.160 --> 01:39.540
Then go ahead and see where the first underscore name is equal to beta, and put a semicolon at the

01:39.540 --> 01:40.080
end.

01:40.110 --> 01:42.540
And let's go ahead and execute this.

01:42.540 --> 01:44.280
And this is what we have.

01:44.460 --> 01:46.860
And you see that Peter Jude.

01:46.860 --> 01:48.810
And this is what we have.

01:49.800 --> 01:54.330
So the request helps you to specify a condition.

01:54.330 --> 01:58.740
And you actually want to filter these out.

01:58.740 --> 02:01.860
And that is where we are process very very important.

02:01.890 --> 02:02.580
All right.

02:02.580 --> 02:05.520
And what do we do right inside Pgadmin.

02:05.520 --> 02:10.080
You can actually do that right in here under the SQL shell.

02:10.170 --> 02:14.220
So I believe the Where clause is very easy going to practice that.

02:14.220 --> 02:18.780
And we're going to use more of that and some lectures to come.

02:18.780 --> 02:20.220
And I believe that we have us a lot.

02:20.250 --> 02:21.360
So practice with that.

02:21.360 --> 02:25.830
And if you have any question or had I use the question and answer section and I'm going to get back

02:25.830 --> 02:27.360
to you as soon as possible.

02:27.390 --> 02:28.440
Thank you so much.

02:28.440 --> 02:32.040
And I'm going to see you in the next video lecture.