adspace


What is difference between group by and order by clause?

Answer Posted / 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       View All Answers


Please Help Members By Posting Answers For Below Questions

How to Change a users password from unix shell.

1223


What is current version of mysql?

1085


What is the current mysql version?

1105


Which statement is used in a select query for partial matching?

1247