Total Answers and Comments: Last Update: December 09, 2006
No best answer available. Please pick the good answer available or submit your answer.
November 09, 2006 06:52:51 #2
anilp
RE: What is the difference between group by and order ... The GROUP BY keyword is used when we are selecting multiple columns from a table (or tables) and at least one arithmetic operator appears in the SELECT statement.
eg1: SELECT NAME FROM TABLE1 GROUP BY ROLLNO
Can use Agregate functions with GROUP BY
EG2:SELECT NAME FROM TABLE1 ORDER BY ROLLNO ASC
Is this answer useful? Yes No
December 09, 2006 18:53:41 #3
Blue Gazoo
RE: What is the difference between group by and order ... Group By forms Groups (of course), but this means it also SORTS; but it will also retrieve a DISTINCT RECORD SET
ORDER BY Sorts by the columns included in the Statement, and does not retrieve DISTINCT Records.
Neither determines the order of the columns (the order of the SELECT Statement does).
Is this answer useful? Yes No
Go To Top
