Hello and welcome to this video.
In the previous video, we have seen that how to create a database, how to add a table to the database
and how to see what all you have created using select start from Notebook Notebook was the name of that
table, which we have created in the previous video.
So now to says again, that table, you have to again go to the school, write down the same grade,
select, start from the day by name, and then you'll see that we have inserted three records into the
table.
So now if I want to filter based on attendance, that means I want to see how many students were present
on the particular day.
So do filter based on attendance.
We have some condition clause, which is known as very close in to that as well.
So I'm going to use this well and I want to put a condition on the column, which is attendance.
So McQuary will be select staff from table.
That means I want to select all the records from the table.
That is notebook where attendance column is equal to the value present so that I'm going to get all
the records whose value is present in to the attendance column.
So you can see that I got only two records because for the serial number two that we have in our data
record that was absent in the attendance column, I'm getting only two records whose value is presented
to the attendance column.
So this is how you can use the word clause and what some conditions to X's and filter the data from
your database.
Okay, so now let's see the records for the Epson.
That means I'm putting a condition that is where our attendance column equals Epson.
So I'm getting only one record that is Schiefer because only to the attendance column absent value is
present with the record Schiefer.
So that's it for this video.
Thank you so much.