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

    How to find datatype of variable in PHP?

    You can find the datatype of a variable in PHP by using the Var_dump() and gettype() functions....

    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...

    Error
    Whoops, looks like something went wrong.