Share
Showing posts with label DESC. Show all posts
Showing posts with label DESC. Show all posts

  • This is some kinds of sorting. If want to find out some portion of your information according to a order then follow the examples-
    SELECT name, cost FROM items WHERE cost>(250) ORDER BY cost DESC
    ELECT name, cost FROM items WHERE cost>( SELECT cost, AVG(cost) FROM items ) ORDER BY cost DESC