SQL GROUP BY statement

OBJECTIVE

In this chapter you will learn:

What is GROUP BY statement
Syntax of group by statement
Example of group by statement

 

What is GROUP BY statement

The group by statement or clause is used to display the result in the group with the aggregate functions. It follows the where statement in a select statement.

Syntax of group by

Select column_list from table_name where condition group by expression

Example of group by statement

 

screen shot of group-by

 

SUMMARY

In this chapter you have learned about group by statement or clause. In the next chapter you will learn about compute by clause.


Leave a Reply

Your email address will not be published. Required fields are marked *