what is the difference between GROUP BY and ORDER BY in sql server query?

Question

what is the differnce between group by and order by in sql server query wih example explaination?

Answer 1

example: select id group by id order by id

GROUP BY - you use this so that no duplicate will exist in IDs.
ORDER BY - means you sorted your id.

So that if you have data like F002, F003,F004,F002,F003,F004...

What returned from your query (from above sample) was: F002,F003,F004

Answer 2

Here below is some resource that maybe helpful for your qs.