Home Blog Page 2

How to filter duplicate in SELECT clause? Section7

How to filter duplicate in SELECT clause

In the previous article we’ve seen how we can be able to implement cange Ivo issuing this statement. We’ve also seen examples using kids when as well as I say in this article we’re going to continue our discussion by looking at filtering in duplicate and a select statement. Let’s see one example here.

When you are working at least you might have to create some reports that is not going to contain any duplicate file use we’re acquiring these Montane table for example you can see a mounted and Rocky’s duplicate that more than 10 times a year. The simplest way for us to filter out this duplicate is using a keyword called District files.

The same query that has this thing. Now you can see that Rocky Mount is only going to appear once. Another way to do it is using a pie so we can get rid of it distinct. But if you use the same columns that we use in the select statement in the group why close that is going to give us the same thing or use as well.

How to use a basic ORDER BY clause?

It the previous movies we’ve discussed about select statement in a sequence of which we’ve seen a basic select statement the sequel. We discuss how we can be able to manage plate number treeing and deathly Trotz. We’ve also discussed how we can be able to carry columns from a table how we can be able to perform some condition.

I’ve always been using this way in as well as functions how we can be able to perform some mathematical operations as well as how we can be able to use some building function inside a select state.


In this article we’ll discuss about order by a cause. Another important state and one in sequent language. Let’s assume we’re working as and at least we were tasked to create a report that is going to follow some sort of an order and to be able to produce these. We’re going to have to implement an ORDER BY clause. There are two kinds of order. There is ascending order.

Then we have to use a s c then b a descending order or D s c a d forth ordering. If we don’t specify an ascending order then if I execute this statement you will see that the state I said is order. Yes and the order population. ORDER BY clause we can also be able to sort using two or more columns for example.

We will like to order Montaigne’s by name then by their elevation in a descending order if I execute this statement you will see that this data is sorted by name first and then by elevation.For example if we look at Rocky Mountains you’ll see that the top peak of the mountain or Moland elbow comes first then the second topic of Montaigne’s which is peaks Pike comes back to the status it is or it is Montaigne’s in ascending form and then with elevation in the informant.

So you can keep adding more columns as you wish for an order by clause. Another way to do an ordering is you can be able to refinance the column order Montaigne’s. The second call on the select statements so this. What this means is use mandis for your first ordering in an ascending format and use elevation on the third column.

This is not recommended practice in production but when you are doing any testing you can quickly type the number to be able to sort but another developer columns here then your orders will not be the same. If you’re using an order number instead of a column name or order by.


Conditional evaluations in SELECT clause – Section6


In the previous article we discuss about pre-build function in sequels or as well as how we can be able to implement them in a select statement. In this movie we’ll discuss how to use a conditional evaluation in a select statement.There are two ways how we can be able to implement conditionally volition select statement the original way how we can be able to do that was using kids when a statement will do case when an evaluation of some sort.

Then what should be the result of that evaluation should it be. And we can repeat a when and then for different conditions. Finally we can put the else statement what should happen if any of the previous conditions are not being met. In a recent version of sequencer Microsoft added this I function. I have some condition this will be a true evaluation. Or what should happen if this is true. Else what should we display.


If this is wrong or false of secure this one one is greater than zero. Then this statement will be executed. Then we’ll see here a greater Also if we execute. This is the atom. I have zero craters on one. This is not true than these Vayu or a laser or be executed said use in a case where or if statement for a string or number literals like the one we did it before we can also be able to implement it in a select statement that is queering from a table or a data set.

For example we are tasked to categorize and c reate.You can create a column called economics that is based on a GDP that have greater than 300 billion to be locked and everything else to be called. Give a little peek. If we execute the sequence statement we’ll see. For Australia it has more than three hander which is four hundred seventeen billion GDP so that it’s categorized as developed here.

But if we look at Afghanistan here it only has 20 billion of GDP so that it was categorized as terrible pink. We can also be able to add additional conditions here. For example if we first categorize this one case when GDP greater than 300 to be called developed in any country that has between 200 and 300 to be called Dave or pink and everything else to be underdeveloped now free execute the select statement again we’ll see Australia being developed.

We haven’t changed any condition on that one. Afghanistan will see under a lot of our GDP is not between a hundred and 300. And you might see other countries like here that’s going to say that the lopin its annual GDP is two hundred forty three billion dollars.


How to change column headings and perform mathematical operations in SELECT? Section5

How to change column headings and perform mathematical operations in SELECT?

In the previous article we’ve seen how we can be able to project or display all these columns from a table as well as how we can be able to display only the top end rolls from a table in this movie you will see how we can be able to change a column hitting inside a select statement and how we can be able to perform some mathematical operation using columns is a select state.

I will also give you some overview of what mathematical operations or functions looks like inside a select statement. In this example some experts predicted that a population of every country in the world will be increasing by a million people in the next five years. And you are asked to call it final. Population value. Thirty five years. In this case what you can do is you can use a select statement a name of a country and our population size plus one million from country.

If you execute the sequence statement without using a column heading you’ll get a name like Australia Afghanistan and other countries. But for the newly created you not have any money in order to give it a column heading for I knew would call quited Cole and you can do as an economy now if execute the sequence statement. It’s going to give me a name of a country as well as the projected population besides using some simple mathematical operation like this.

Once the calls are also has some pre-built functions like this for example. In this case we want to calculate the total area in a row of every lake in the world that we can execute this one. This is going to be our total area in an average area of every link in the world. SQL Server also follows a mathematical rule or Mars or Rockett older division multiplication by addition and subtraction.

Like for example in this case we have two plus three times for the result. Could it be two plus 3 which is 5 5 times 4 which is 20. But because of bored us sequel server won’t finish multiplication ahead of time then it’s going to be three times four. Which is 12 plus 2. It is 14. So if we execute this month then we’ll get 14. But if we want to change how this operation works and we want to add two and three fourths then multiply it by 4.

We can use a bracket since the bracket comes first. The important rule then this will be calculated ahead of time. Then the result will be multiplied by four. Two plus three will be five lifetimes or is going to be 22. Now if I execute this statement I’ll get twenty.

How/ Why comments in SQL? Section3


In a previous article we’ve seen how we can be able to create the data is using a sequence script as well as a Server Management Studio features. We’ve also created in set up our sample data. We’ve also seen how we can be able to leverage drag control functionality in SSME so that we can be able to expedite it.

RC called development process we’ve seen how we can be able to select the top 1000 from any table. In it means without having to write any query so that we can be able to see what’s the structure of that table. If we are not familiar with that database we’ve seen how we can be able to change data in this context in a multi data environment.

This will be rather is going to be a very short one. We’ll see why we need comments as well as how we can be able to write comments and comments are a text input which are normally ignored or that are not going to be interpreted by sequencer but comments will play a major role in providing additional information about Sikorsky that we are creating.

Especially in a big database project that involves multiple developers. Sokolski it’s usually you’ll have who the author of that script is. What’s the purpose of the story. And then if there is any additional comments. And when was this screwed you did. Who created it. And if there are going to be multiple revisions to that original script we’re going to be adding the date of the revision. Who is the person who revised it. Why was there a change from the initial version. We need to specify that we also need to specify a usage of the script itself.

How is it going to be executed is it going to be executed from some windows job or is services going to call it or an API is going to call all sorts of procedures all that has to be specified so that the next person who will pick up are called to continue to evolve that will have a warning for Mission y. The script was read in what the purpose of that script is and how it’s going to be used. There are two forms sort of comments in sequence.

One is a multi-line com which is a C style comment. This is a novel he meant I am ready if I continue Adim additional lines. All of them is going to be commented out and till I add my closing syntax which is astri’s plus slush the other form of commenting is using double dashes for a single line. This is all in common. If I can teach me to try ears you’re not going to be combing.

But if I want to comment this want I can always go ahead and comment each line. Or we have additional feature in management studio we can uncomment these single line comments at once or we can comment them like this or we can do it control key control you to uncomment all control key.

Control-C to comment multiple lines together at the same time. This is what comments looks like in the course of Azi in the next article.