groupby is used to show the table in ascending order where as orderby is u

What is the difference between GROUP BY and ORDER BY in
Sql?

Question Posted / ranjani

Answer Posted / ranjani

groupby is used to show the table in ascending order
where as orderby is used to show the table in any order or
same order.

Is This Answer Correct ?

9 Yes

66 No

Please Help Members By Posting Answers For Below Questions

Which storage engine is best in mysql?

892

What is mysqli_connect_error ()?

971

What is sql vs mysql?

963

Will mysql remain free?

903

What is the difference between procedure and function in mysql?

957

How to control the max size of a heap table?

931

What is mysql57?

858

How do you flush privileges?

914

Is mysql a database?

886

What is a join in mysql?

847

What is different between sql and mysql?

954

If you wish to encrypt the username and password using php, how will you do that?

964

What are stored procedures and functions?

857

How big is a blob mysql?

847

Consider you have the following three tables which have to be linked together.

854