Learn T-SQL Commands with Samples
Skip Navigation Links
Skip Navigation Links.
Expand DatabaseDatabase
Expand TableTable
Expand ViewView
Expand Stored ProcedureStored Procedure
Expand Data FilteringData Filtering
Collapse Data GroupingData Grouping
Expand JoinsJoins
Expand TriggerTrigger
Expand CursorCursor
Expand OperatorsOperators
Expand ConstraintsConstraints
Expand FunctionsFunctions
Expand Conditional ProcessingConditional Processing
Expand LoopingLooping
Expand Error HandlingError Handling
Expand v.IMP Queriesv.IMP Queries
Expand XMLXML
Expand Query PerformanceQuery Performance
Expand QueriesQueries
Expand NormalizationNormalization
Expand CreateCreate
     

Group By

  
      

      
EMP


      

      ID
      Name
      Country
      Salary
      


      

      1
      Vijay     
      India     
      6000
      


      

      2
      Bill      
      USA       
      8000
      


      

      3
      Kris      
      France    
      3000
      


      

      4
      Bhagat    
      India     
      2000
      


      

      5
      Steve     
      USA       
      1000
      


      

    
      SELECT    Country, SUM(Salary) as 'Total Wages'
      FROM      EMP
      GROUP BY  Country
    
      

      
Output


      

      Country
      Total Wages
      


      

      France    
      3000
      


      

      India     
      8000
      


      

      USA       
      9000