Follow this topic

Last answered:

02 Dec 2022

Posted on:

01 Dec 2022

0

Resolved: confusion using group by and order by

in SQL / Using Aliases (AS)

does it is neccesary to use 'group by' with 'order by' always and vice-versa

1 answers ( 1 marked as helpful)

Tsvetelin Tsonkov

Instructor

Posted on:

02 Dec 2022

0

Hi Ayush!
Thanks for reaching out.

No, it is not mandatory. The ORDER BY clause is simply to sort the result set.

Hope this helps.
Best,
Tsvetelin

Helpful answer

Submit an answer

related questions

3

28

Rollback not reverting DB state after using INSERT INTO

Alessandro Imbrìaco

2

26

Resolved: Explanations to questions 15 and 29

Islam Elkhateeb

3

24

Resolved: can't add row, I do may trail and it all back with errors

Marcus Wern Han Leong

2

16

Why did you not do not null, primary key and auto increment for customer id in the solution?

0

14

error code 1140 : in aggregated query without group by

0

12

Resolved: SELECT first_name FROM employees GROUP BY first name did not work properly

Ramsey Alizadeh

0

10

SQL’s Order Of Execution

Jose Luis Loren

4

10

Alternative code using group by