The difference between order by and group by in SQL _mssql

Order by is understood in English as the sort of row, and the default is ascending. The ordered by must be followed by a list of field names, which can be multiple field names.

Group By is understood in English as grouping. You must have an aggregate function to work with, and you need at least one group label field when you use it.

What is "aggregate function"?

Like sum (), COUNT (), AVG (), etc. are "aggregate functions"

The purpose of using group by IS to subtotal data.

Generally like:

Select Unit name, COUNT (worker id), sum (Worker's salary) Form [table]

Group BY organization name

The result of this operation is to "unit name" as the classification of statistics units of the number of employees and total wages.

In the order in which the SQL command format is used, group by is preceded by.

The standard format for the Select command is as follows:

SELECT select_list 
[into new_table] from 
table_source 
[WHERE search_condition] 
[GROUP by GROUP_BY_EX Pression] 
[having search_condition]

The above is a small set of SQL to introduce the order by and group by the difference, I hope to help everyone, if you have any questions welcome to my message, small series will promptly reply to everyone!