Original subtitles

0 Now, Let us learn how to find out minimum and maximum value from a particular column 1

For that 2

Min and max functions are used 3

Syntax for using min and max function is as follows 4

You type select 5

Min then you give the expression 6

You can mention other column names also if you want to 7

From 8

Table 9

The table name 10

Where 11

You can specify the where condition if you want to 12

Same is the syntax for max function just you have to replace the min with max 13

Let us look at an example 14

Suppose you want to find out 15

The Minimum sales value that you had in the month of 16

June 2015 17

To do that 18

You need to select the minimum of sales value 19

From the table 20

Where order date is between 21

1st June 2015 and 30th June 2015 22

Let us go and write this query 23

So lets write, select 24

Min 25

The column name is sales 26

As 27

As 28

Minimum sales 29

Value 30

June 31

From the table name where 32

The Order date 33

Is between 34

1st June 35

So we have to write YYYY 2015 is the year 36

MM 37

And DD 1st June and 30 June 38

2015-06-30 39

2016-06-30 40

; 41

Select query 42

And run it 43

So 0.984 is the minimum value of sales order that I received in 44

The month of June 2015 45

To Verify this value let us find out the total sales values and order 46

It into ascending order so that the first value that we have 47

Is the minimum value 48

And order by I hope you remember order by statement 49

Order by 50

Sales ascending 51

If you don't mention it by default is ascending 52

So you can see 53

We have received all the sales values and the minimum is 0.984 54

Now let us work out the maximum value using the max function 55

It Will be exactly same 56

We just change the min to Max 57

So lets just select the query and copy it 58

And change min to Max 59

And rename the column as maximum sales value 60

And run this query 61

The maximum sales value in the month of June 2015 for me was 62

3050 63

Units 64

You can check it by again running the previous query 65

In the descending order so you can see the largest values is 66

3050 67

Unit 68

So this is how we use the Min and Max functions 69

In the next lecture, we will learn about group by function