Difference Between Sort By, Order By & Group By

AI Thread Summary
The discussion centers on the differences between "Sort By," "Order By," and "Group By" commands in databases. "Order By" is confirmed as the standard SQL command for sorting query results, while "Sort By" is associated with Query by Example (QBE), particularly in Microsoft Access. QBE is described as a visual querying method that simplifies database interactions, similar to how a graphical user interface (GUI) contrasts with command line operations. The conversation highlights the context in which these terms are used and clarifies their applications in different database environments.
WWGD
Science Advisor
Homework Helper
Messages
7,678
Reaction score
12,354
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.
 
Last edited:
Technology news on Phys.org
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
 
Dear Peeps I have posted a few questions about programing on this sectio of the PF forum. I want to ask you veterans how you folks learn program in assembly and about computer architecture for the x86 family. In addition to finish learning C, I am also reading the book From bits to Gates to C and Beyond. In the book, it uses the mini LC3 assembly language. I also have books on assembly programming and computer architecture. The few famous ones i have are Computer Organization and...
I have a quick questions. I am going through a book on C programming on my own. Afterwards, I plan to go through something call data structures and algorithms on my own also in C. I also need to learn C++, Matlab and for personal interest Haskell. For the two topic of data structures and algorithms, I understand there are standard ones across all programming languages. After learning it through C, what would be the biggest issue when trying to implement the same data...
Back
Top