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?
You can find the datatype of a variable in PHP by using the Var_dump() and gettype() functions....
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...