What is difference between Group by and order by clause in MYSQL?

devquora
devquora

Posted On: Feb 22, 2018

 

Both GROUP and ORDER BY clauses are used for organizing data in MYSQL.

  • ORDER BY clause is used to sort the query result by specific columns.
  • GROUP BY clause is used to summarize unique combinations of columns values.

    Related Questions

    Please Login or Register to leave a response.

    Related Questions

    Appinventiv Php Developer Interview Questions

    What is Interface? Why it is used?

    An interface can be defined as a platform that permits users to develop programs that mention all public methods that need to be implemented by various classes. It does not involve any complexity or d...