This we are going to talk about a yes. So SQL alias are used to give a table or a column. Name, but a temporary name. How if I'm selecting all the records from the tables, students, now I'm going to hit the enter button by pressing Ctrl Enter to make flowers in senior semester. Follow me IDs IDs name as city and address. If I'm saying that select not static in this time, I'm saying as city as a city, where from students then here What are you saying you are saying that Oh, issue me this color, but change the column name City controller so now you can see it's showing you the name of the column is city if you are saying city s parcel if you are saying I city ICT can hold in touch now you can see showing you the results as my city because you are saying that oh please show me this column as this so this is that temporary name as you know you don't have this name.
As you can see, the my city or the city column is not a cyst vertical, it's straight, showing you the record. You can also specify the multiple you or you can say select, I'm saying as city as city and now I'm saying with commas separate or symbolizing s ID as ID, students semicolon to terminate the statement or code Enter To execute the query Ctrl Enter. So now you can see me showing you the records with the temporary name, city name. So v. s IDs IDs is see this is the ID and this is the city if you solely depend upon you how you are managing and how you're using the service. If you are saying that selectors vary from student as my SGD it goes in depth. Now as you can see, it's showing you the results like this.
But don't worry, we will discuss about this if we have more than one tables. So for now, we have Now, you know the basics How can you use the weight loss and order by and you know they have all the areas anyway very well how can you use multiple search with using the weight loss? Yes we have discussed about in and we have discussed about insert values. Now, we will discuss about some topics, some cases topics after that we will discuss about the joints. So, what are joins we will discuss about it. But for now I'm just telling you that if you get the results from two difference table, so, you always use the check.
So don't worry, we'll discuss our Strike Force