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

WWGD · Mar 24, 2015

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 · Mar 24, 2015

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

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

WWGD · Mar 24, 2015

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

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

Discussion

Similar threads

Python Unsolvable python code bug? (finding the difference between two input strings)

Undergrad Age difference between Steve and Steveston given the pattern