What is difference between group by and order by clause?



What is difference between group by and order by clause?..

Answer / Om Prakash Divakar

The GROUP BY clause in SQL is used to group rows that have the same values, while the ORDER BY clause is used to sort the results. The GROUP BY clause comes after the WHERE and HAVING clauses, if used, and before the ORDER BY clause.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More MySQL Interview Questions

How would concatenate strings in mysql?

1 Answers  


Is mysql a dbms?

1 Answers  


What is longblob?

1 Answers  


How do you control the max size of a HEAP table?

1 Answers  


How to use 'mysql' to run sql statements?

1 Answers  


How can we run batch mode in mysql?

1 Answers  


Can mysql store files?

1 Answers  


How do I disable mysql?

1 Answers  


How would you get the current date in mysql?

1 Answers  


What is difference between statement and preparedstatement?

1 Answers  


What are the benefits of mysql?

1 Answers  


how you will Create a database on the mysql server with unix shell.

1 Answers  


Categories