SQL MAX () and Min Function Example tutorial

SQL Max () and Min Function Example tutorial Okay, let's take a look at the SQL Max Tutorial.

SQL MAX () syntax.

SELECT MAX (column_name) from table_name

Here's a look at the SQL Max instance.

 
  
  

  
   
   
 
    
 
     
Id
 
     
OrderDate
 
     
Orderprice
 
     
Customer
 
    
 
    
 
     
1
 
     
2008/11/12
 
     
1000
 
     
Hansen
 
    
 
    
 
     
2
 
     
2008/10/23
 
     
1600
 
     
Nilsen
 
    
 
    
 
     
3
 
     
2008/09/02
 
     
700
 
     
Hansen
 
    
 
    
 
     
4
 
     
2008/09/03
 
     
300
 
     
Hansen
 
    
 
    
 
     
5
 
     
2008/08/30
 
     
2000
 
     
Jensen
 
    
 
    
 
     
6
 
     
2008/10/04
 
     
100
 
     
Nilsen
 
    
 
   
 
  
  

SQL syntax.

 
 SELECT MAX (orderprice) as Largestorderprice from Orders 
 
   
 
 output results are 
 
 &
nbsp. 
 let's look at an example of the SQL Min function, which has the same syntax as Max and I don't write it. 
 SELECT Min (orderprice) as Largestorderprice from Orders 
   
 
 output is: