We are going to discuss about the SQL in statement. So you cannot say certainly use SQL in operator. So the end operator allows you to specify multiple values in a where clause. So how you know very well that we have added water. That's why I need to insert some records. So I'm saying insert into tables.

Now here I'm saying, oh, sorry, here I'm saying student. And the values are I'm saying that these are the values. Now I'm not going to now I'm saying this is a john. JOHN, and the city is an awful lot Landon. And this is x y Zed x y Zed. Learn desired press Control Enter, I have added one record.

Now this time I'm saying Alex, he's living or suppose Paris, Control Enter, control, enter, I have added second record, third, fourth, fifth, sixth. Now if I'm saying select the static from student so now as you can see you change the sixth record. So four records 123455 records with me LS in Paris, one record with named john and eliminate learner now I say that I'm going to insert another record students and now I'm saying without having this And now I'm saying the values are. Now I'm thinking, sexy Karachi, and now it's wiser Karachi, control Ctrl, enter. Now I'm saying select Sperry from students semicolon to terminate your statement Ctrl Enter To execute a query. So now you have three records.

If you use in that if you find something if I'm saying select static from student s name equals to check the definitely it will give you the one record. So as you can see, it's giving you the one record or suppose if you want to Use or if you want to specify the multiple values in your club. So how can you do that? I'm saying that select this pairing You can also specify the column from students tables. Now I'm saying where s name in so this is the end and two braces. And now specify your name here.

I'm saying select the record. And now I'm saying where the values is chikezie. JOHN are suppose this film is not access control in terms of how they conceive Seamus three values, because these three values available in the database. So now if I'm saying that, select static comes to rent, control, enter, see it's showing us these values 123456 Seven records. As you can see, it's also showing you the seven records seven rows returning from your tables. Now, if you use See, I'm saying that select static from students where as name in you can also use the small formula depend upon you.

Or suppose I'm saying in this time I'm saying Alex, this is not exist in the table. And this really is not as integral control interface. So now as you can see, it's showing us the value. It has the LS. So if you want to specify the multiple values in a where clause, you have to use the in operator. So if I'm say, if I say that find the, the JC and also the john told me that it shows you all the record records you have these three names available in last name, okay if you if you are searching from the city you can specify that Landon sorry, STD control in there it's forcing you in order to cause these string is not available in the city column if I'm saying that London it's all in there and we have the only single record in the table which has the London value.

So you can specify the Select static prompts rent controls, as you can see we have only single records with the value of land. So in this way you can use the in operator to specify the multiple dwelling unit class. So I think this is enough for later so we are going to cover some of the topics so thank you for watching.