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 2 of 2
  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.  

  3. #2
    Junior Member
    Join Date
    Aug 2019
    Posts
    20
    Member #
    60927
    Liked
    4 times
    SELECT * FROM table ORDER BY date, score LIMIT 15


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 07:50 AM.
Powered by vBulletin® Version 4.2.3
Copyright © 2019 vBulletin Solutions, Inc. All rights reserved.
vBulletin Skin By: PurevB.com