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

How do I rename a mysql database?

957

What does a TIMESTAMP do on UPDATE CURRENT_TIMESTAMP data type?

942

how to display nth highest salary from a table in a mysql query? : Mysql dba

1066

What is triggers and how it can be used in mysql?

975

What is dirty read and phantom read?

878

Explain triggers and stored procedures?

928

What is pdo mysql?

946

Is mysql a odbc?

925

What is difference between mysql and mysqli?

921

How do I save in mysql?

968

Is mysql same as sql?

898

What is table level locking in mysql?

920

How do I kill a mysql connection?

906

How many columns can you create for an index?

954

Explain % and _ inside like statement?

1018