All language subtitles for 2. ORDER BY

Now, let us start with the order by command
1

This command will help us sort our results, so till now we have been filtering our resultset, we have been applying
2

filters
3

To get particular data, which is specifying particular conditions
4

Now the result that we have received, we want to sort it in a particular order, to sort the data we'll use
5

Order by
6

How to use order by
7

Select the columns from the table name
8

Put the condition if you want to
9

So that is an optional part, then you write order by
10

And then you tell the column name with which you want to order it
11

Then you you specify in ascending order or in the descending order
12

It is possible that you specify more than one column
13

And you can specify
14

And you can specify whether you want to do ascending descending
15

Ordering with column 1 and ascending descending order with column 2
16

That is also possible, we will see that in the examples
17

So in the first example
18

What we are trying to get is
19

If you want to find out all the customers
20

Who
21

Reside in the state of California
22

And
23

We want that result to be ordered by the customer name
24

If I just write order by customer name
25

It will automatically order it in the ascending order
26

If I write this ASC keyword also
27

It will
28

Do the same thing, so both of these commands are same
29

Let's go and write this command and see what is the result that we get
30

We want to find out everything select star
31

From customer
32

Where the state
33

Is California
34

And we want to order it by
35

The customer name
36

Let us run this command
37

So you can see
38

You Scroll it to the right
39

All these customers have the state California, this was specified in the where condition
40

And
41

The customer names
42

Are arranged in the alphabetical order so first
43

Is Allen
44

Then comes
45

Customer with name starting with B then comes customer with name starting with c
46

And so on
47

So they are
48

Arranged alphabetically
49

In Ascending order
50

If you want to arrange them in descending order
51

Just add the keyword for descending
52

Order by
53

Customer name
54

Then you specify the keyword
55

Descending DESC
56

So you can see
57

The Customer names are now in descending order, with starting with Z
58

Then Y
59

Then X and if you go down it will be ending with
60

Customer name starting with A
61

You can give two column names at the same time while ordering
62

If you want to
63

First
64

Order the data
65

With city in ascending order
66

And then you want to arrange the data according to the customer name in descending order
67

That can also to be done
68

So
69

Let us start writing that query
70

We will order the
71

Data in ascending order with city name and descending with
72

Customer name
73

Order by
74

City
75

ASC
76

By
77

Customer name descending
78

Run this query
79

First look at the City part
80

This
81

You can see cities are arranged in ascending order
82

Starting with A going down
83

Then comes B C and so on
84

The first two have the same city
85

So their customer name
86

Is arranged in descending order, you first get a customer name is starting with M then you get
87

Starting with e
88

Same is with the next
89

City
90

That's how first it is sorting the data using the city column
91

In ascending order
92

Then it is arranging the data
93

In descending order with the customer name
94

While ordering the data
95

Instead of mentioning the column name you can also specify the column number
96

You can write something like this
97

Order by
98

This is the column number 2
99

In our data column number 2 is customer name, So if you like this it will
100

Order the data in descending order
101

With customer name
102

And you can also use
103

Columns which are non textual so if you use a column which has
104

Age which will be an integer
105

It will order the integers in ascending or descending order so
106

Let's do both of this things
107

So let's order this data using the column number
108

Which is 2
109

Order by 2
110

Ascending
111

You can see
112

This is ordered in the
113

The customer name, which is the column number 2
114

Is used to
115

Sort the data in ascending order
116

Now let us sort
117

Sort
118

The customers
119

Basis their age
120

We have the customers who have maximum age on top and minimum at the bottom
121

So We'll be arranging them in the descending order
122

Order by age
123

Descending DESC
124

Run it
125

You can see
126

There are several customers
127

With age
128

70 then comes 69 and so on
129

So
130

Both strings and integers can be used to sort the data
131

If it is a string it will be sorted in a to z Or z to a manner basis the
132

Keyword you have used ascending or descending
133

If it is a integer
134

It Will be arranged in smallest to largest or largest to smallest
135

Basis the ascending descending that you have specified
136

If you have not specified anything it will be ascending by default
137

That's how we Sort the data
138

In the next video
139

We'll learn how to limit the
140

Number of rows that we are getting back when we run a query