按日期和日期排序时间降序排列? [英] Sorting by date & time in descending order?
问题描述
全部 我想显示最后5个输入的特定ID的数据. 我的SQL查询是
all I want to display last 5 entered data for specific id. My sql query is,
SELECT id, name, form_id, DATE(updated_at) as date
FROM wp_frm_items
WHERE user_id = 11 && form_id=9
ORDER BY updated_at DESC
updated_at
是DATETIME
updated_at
is DATETIME
它显示按日期而不是时间排序的最后5个条目.然后在同一日期按字母顺序排序.
It displays last 5 entry sort by date not by time. On same date then it is sorting alphabetically.
假设我在同一日期有3个条目,且带有差异时间
Suppose i have 3 entries in same date with diff time
说
Ajay 1/3/2012 1:15
John 1/3/2012 1:00
Bony 1/3/2012 1:10
查询上述查询后
我得到的是
Ajay 1/3/2012 1:15
Bony 1/3/2012 1:10
John 1/3/2012 1:00
按日期排序,然后按字母顺序排序
Sort by date then after alphabetically
我想要的是这个..
John 1/3/2012 1:00
Bony 1/3/2012 1:10
Ajay 1/3/2012 1:15
还按日期和时间排序...
Sorted by date and time also...
推荐答案
如果您想要最后5行(以升序排列),则需要一个子查询:
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
第10次阅读问题后,这可能是(可能只是)您想要的.按日期顺序降序,然后按时间(同一日期)升序:
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
这篇关于按日期和日期排序时间降序排列?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!