So now it's time to discuss about the weight loss. So what is weight loss? First of all I'm saying so select stealing from students enroll in. So it's giving us all the records from a table to the students. Now, the where clause is used to filter a record how the where clause is used to extract only those records that fulfill a specific condition. Or suppose you are saying, Oh, please show me the records.
Who has one Id make sure I'm talking about the SI. So how can you do that? I'm saying select steric from his students. Now, same use WHERE clause so WHERE clause we can also use small or capital for you depend upon and saying select Static from where? From student where s ID. So s ID is a condition.
I'm saying where s ID one. Here I'm saying, Oh, please show me all the records from the student tables, who has s ID. So Ctrl, Enter To execute the query. So as you can see, it's showing us only one ID, or and you can also say, Oh, please show me all the record from the student tables, who has the S name equals to Shakespeare. Now I'm saying because this is the integer field, this is their tsp. So that's why I'm using without single or double petition, if I could, and this this this, these are the strings field, so that's why we need to use the single or double petition.
Now I'm seeing that s name. Sue me all the records from Square tables where s name equals two. Now I'm saying shift c Ctrl. Enter To execute the query. So now as you can see, it's showing me only two records. Because the s we have only two records in our table name changes with xy, where clause filter your results.
For suppose if I'm saying Oh, please show me the address, S, address s, address. This Control Enter. So as you can see, it's showing you the will call sheets these are the fields. So in this way, you can use the where clause, if you are using the one column for suppose I only need the address column s. Address column. So I'm saying Oh, please show me only a single column from this current Now I'm saying, Here I'm defining the criteria, or I'm giving the conditions now Ctrl, enter. So you can see it's only giving me the single column, or I'm here saying, Please give me the single column.
Or you can also use select this thing and call it so you can see it's only giving you the unique results. So now it's totally depend upon you how you are logic and what you need. So you can okay so I think this is enough rain in the next lecture we are going to cover some other topics for servers and or nodes. Thank you for watching.