Dismiss Notice
Join Physics Forums Today!
The friendliest, high quality science and math community on the planet! Everyone who loves science is here!

Sort by Vs Order by?

Tags:
  1. Mar 24, 2015 #1

    WWGD

    User Avatar
    Science Advisor
    Gold Member

    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: Mar 24, 2015
  2. jcsd
  3. Mar 24, 2015 #2
  4. Mar 24, 2015 #3

    WWGD

    User Avatar
    Science Advisor
    Gold Member

    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
     
Know someone interested in this topic? Share this thread via Reddit, Google+, Twitter, or Facebook




Similar Discussions: Sort by Vs Order by?
  1. Selection sort? (Replies: 2)

  2. Sorting algorithm? (Replies: 2)

  3. Perfect sort (Replies: 2)

  4. Merge sort (Replies: 1)

Loading...