1
00:00:01,140 --> 00:00:02,960
Hello and welcome to this video.

2
00:00:02,970 --> 00:00:09,690
In the previous video, we have seen that how to create a database, how to add a table to the database

3
00:00:09,690 --> 00:00:17,310
and how to see what all you have created using select start from Notebook Notebook was the name of that

4
00:00:17,310 --> 00:00:19,930
table, which we have created in the previous video.

5
00:00:20,220 --> 00:00:26,430
So now to says again, that table, you have to again go to the school, write down the same grade,

6
00:00:26,550 --> 00:00:33,450
select, start from the day by name, and then you'll see that we have inserted three records into the

7
00:00:33,450 --> 00:00:33,940
table.

8
00:00:34,290 --> 00:00:42,090
So now if I want to filter based on attendance, that means I want to see how many students were present

9
00:00:42,090 --> 00:00:43,630
on the particular day.

10
00:00:44,040 --> 00:00:47,670
So do filter based on attendance.

11
00:00:47,670 --> 00:00:53,460
We have some condition clause, which is known as very close in to that as well.

12
00:00:53,700 --> 00:01:00,540
So I'm going to use this well and I want to put a condition on the column, which is attendance.

13
00:01:00,540 --> 00:01:04,580
So McQuary will be select staff from table.

14
00:01:04,590 --> 00:01:07,770
That means I want to select all the records from the table.

15
00:01:07,770 --> 00:01:17,610
That is notebook where attendance column is equal to the value present so that I'm going to get all

16
00:01:17,710 --> 00:01:22,790
the records whose value is present in to the attendance column.

17
00:01:23,310 --> 00:01:31,200
So you can see that I got only two records because for the serial number two that we have in our data

18
00:01:31,200 --> 00:01:38,780
record that was absent in the attendance column, I'm getting only two records whose value is presented

19
00:01:38,790 --> 00:01:40,120
to the attendance column.

20
00:01:40,440 --> 00:01:48,120
So this is how you can use the word clause and what some conditions to X's and filter the data from

21
00:01:48,120 --> 00:01:49,080
your database.

22
00:01:49,440 --> 00:01:52,990
Okay, so now let's see the records for the Epson.

23
00:01:53,130 --> 00:01:58,830
That means I'm putting a condition that is where our attendance column equals Epson.

24
00:01:59,100 --> 00:02:08,100
So I'm getting only one record that is Schiefer because only to the attendance column absent value is

25
00:02:08,100 --> 00:02:11,450
present with the record Schiefer.

26
00:02:11,850 --> 00:02:14,490
So that's it for this video.

27
00:02:14,520 --> 00:02:15,660
Thank you so much.
