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.