Register

If this is your first visit, please click the Sign Up now button to begin the process of creating your account so you can begin posting on our forums! The Sign Up process will only take up about a minute of two of your time.

Results 1 to 1 of 1
  1. #1
    Junior Member
    Join Date
    Jun 2018
    Posts
    10
    Member #
    59288

    Sorting by two fields

    There is a table with the fields name, date, score
    Sort the sorted last 15 records by date, displaying them in descending order by score
    this request works incorrectly:
    SELECT * FROM table ORDER BY date, score LIMIT 0,15
    XoXo 22coders

  2.  


Remove Ads

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
All times are GMT -6. The time now is 10:02 AM.
Powered by vBulletin® Version 4.2.3
Copyright © 2019 vBulletin Solutions, Inc. All rights reserved.
vBulletin Skin By: PurevB.com