How to query data group by with order by in oracle?

@herminia_bruen 

To query data in Oracle with both GROUP BY and ORDER BY clauses, you can use the following syntax:

1
2
3
4

SELECT column1, column2, aggregate_function(column3)
FROM table_name
GROUP BY column1, column2
ORDER BY column1, column2;

In this syntax:

• column1, column2, and column3 are the columns you want to select and group by.
• aggregate_function is the function you want to use for the grouped data, such as SUM, AVG, MAX, MIN, etc.
• table_name is the name of the table containing the data you want to query.

For example, if you have a table called sales with columns region, year, and total_sales, and you want to find the total sales for each region in ascending order of region, the query would look like this:

1
2
3
4

SELECT region, SUM(total_sales)
FROM sales
GROUP BY region
ORDER BY region;

This query will group the data by region and calculate the sum of total sales for each region, then order the results by region in ascending order.