What is difference between Group by and order by clause in MYSQL?
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
Subscribe Our NewsLetter
Never Miss an Articles from us.
Recent Articles
Featured Categories
- Common Interview Questions
- Python Flask Interview Questions
- NoSQL interview questions
- JQuery Interview Questions
- C programming interview questions
- AngularJS Interview Questions
- Node JS Interview Questions with Express
- JavaScript Interview Questions
- Core Java interview questions
- HTML Interview Questions
- Laravel interview questions
- Wordpress Interview Questions
- PHP Interview Questions
Appinventiv Php Developer Interview Questions
How to find datatype of variable in PHP?
...
Appinventiv Php Developer Interview Questions
Difference between get and post method.
Some differences are:..
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...