Difference between sort by, order by and group by in databases

[WWGD]

Hi, just curious about the difference between the " Sort By " and " Order By" commands in database. I assume Sort by is used in QBE and "Order by" is used in SQL ? While we're at it, how about "Group By"?
Thanks.

 

[Greg Bernhardt]

SQL uses "ORDER BY". Where have you seen "SORT BY"? What is QBE?

http://www.thetricky.net/mySQL/GROUP+BY+vs+ORDER+BY

 

[WWGD]

Thanks, Greg, I think Access uses "Sort By" . QBE is an abbreviation for "Query by Example" , a visual, high-level way of doing
a query; QBE is to SQL as GUI is to Command Line.

http://www.webopedia.com/TERM/Q/query_by_example.html