SQL GROUP by use method

SQL GROUP by use method

Group's statement
A group declaration is a combination of the overall function of the set of results set by one or more columns.

SELECT column_name, Aggregate_function (column_name) from
table_name
WHERE column_name operator Value
GROUP by column_name

Let's take a look at an example, the datasheet I used to not write a direct view of the SQL statement.

SELECT Customer,sum (orderprice) from Orders
GROUP by Customer

Output results.

  
  
  

   
   
   
 
    
 
     
Customer
 
     
SUM (Orderprice)
 
    
 
    
 
     
Hansen
 
     
2000
 
    
 
    
 
     
Nilsen
 
     
1700
 
    
 
    
 
     
Jensen
 
     
2000