SQL LAST () function instance tutorial

SQL LAST () function

The selected column for the final value returned by the LAST () function.

LAST () syntax

SELECT LAST(column_name) FROM table_name

Let's look at a simple example.

 
 

  
  
 
   
 
    
 
 
    
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
 
   
 
  
 
 

Now, we are looking for the "OrderPrice" column of the final value.

The following SQL statement is used:
 
SELECT LAST(OrderPrice) AS LastOrderPrice FROM Orders
 
Output result.
 
  
  

   
   
 
    
 
     
LastOrderPrice
 
    
 
    
 
     
100