Today we are going to discuss about SQL between operator you know we will allow the in operator and you know we will allow the operators in programming language but for now I am talking about the between operator in SQL. So now as you know, you have the ID from a 14. So, if I want to view the records between 814 How can I do that the syntax is select from which color I'm seeing as ID from which table the table in goes here and where your column name, column name use the between operator your value one here And while you two here. So this is a set test, you are saying, Oh, please show me only a single column from my table, you use the weight loss, which column between v1 and v3 to make sure this is now I'm saying select the steric from students, okay?
Where I have to specify the column name. Because we have the digital values we only have integer values in so I'm saying where as Id between you have this why well one I'm saying a, and I'm saying 40. So now execute your query by pressing Ctrl and hit the enter button. Now as you can see, it's showing you the results. The between eight and 14 if I'm saying Show me the reserves between eight to 10. The control index now as you can see, it's showing you the results between eight to 10.
Because it also eight and 10 also included with, but it's showing you also the nine because if I'm saying 12 so hit the control interpreters now is showing you that records between eight and 28 and 20 also included in the SQL statement. So in this way you can use the in condition. You can also use the between operator for multiple records for suppose. Select the static from your tables from your table from the students, sorry, students and now here I'm saying You can also specify like this, I'm saying where you can use the bracket where I'm saying possible as Id between for suppose 120, sorry 101 and four symbols and all in there. So now they can see you saying you from one end, well, you can say, from nine to 12, that whole intersection from nine to 10. And if you are applying the between operator to multiple values, so how can you do that I'm saying and not and also in your second statement goes here.
First of all, get any ID or if you have no other columns so i think is enough for the next issue. We are going to ask always thank you for watching