Sorting by date & time in descending order?

by

If you want the last 5 rows, ordered in ascending order, you need a subquery:

SELECT *
FROM
    ( SELECT id, name, form_id, DATE(updated_at) AS updated_date, updated_at
      FROM wp_frm_items
      WHERE user_id = 11 
        AND form_id=9
      ORDER BY updated_at DESC
      LIMIT 5
    ) AS tmp
ORDER BY updated_at

After reading the question for 10th time, this may be (just maybe) what you want. Order by Date descending and then order by time (on same date) ascending:

SELECT id, name, form_id, DATE(updated_at) AS updated_date
FROM wp_frm_items
WHERE user_id = 11 
  AND form_id=9
ORDER BY DATE(updated_at) DESC
       , updated_at ASC

More Related Contents:

  1. Which DB technology is sued to solve the following search issue? [closed]
  2. MySQL pivot row into dynamic number of columns
  3. Delete all Duplicate Rows except for One in MySQL? [duplicate]
  4. What’s faster, SELECT DISTINCT or GROUP BY in MySQL?
  5. MySQL – Operand should contain 1 column(s)
  6. How to get the difference in years from two different dates?
  7. Restore table structure from frm and ibd files
  8. mysql pivot/crosstab query
  9. MySQL: Split comma separated list into multiple rows
  10. Most efficient way to get table row count
  11. UNION query with codeigniter’s active record pattern
  12. Mysql Convert Column to row (Pivot table )
  13. Merge two tables in one SQL query and make the date values unique
  14. Remove Primary Key in MySQL
  15. Get most recent row for given ID
  16. Checking a table for time overlap?
  17. Does mysql have the equivalent of Oracle’s “analytic functions”?
  18. MYSQL select DISTINCT values in two columns
  19. Storing IPv6 Addresses in MySQL
  20. Insert/ Update random date in MySQL
  21. Replace null with 0 in MySQL
  22. Get total hours worked in a day mysql
  23. mysql count group by having
  24. SQL UPDATE with sub-query that references the same table in MySQL
  25. Equivalent of MySQL ON DUPLICATE KEY UPDATE in Sql Server
  26. How to store a one to many relation in MySQL database?
  27. MySQL – Complexity of: SELECT COUNT(*) FROM MyTable;
  28. How to count date difference excluding weekend and holidays in MySQL
  29. Execute multiple semi-colon separated query using mysql Prepared Statement
  30. mysql unique number generation

Leave a Comment