在使用LIMIT后如何对结果进行排序?

This is kind of straight forward. I want to ORDER BY date DESC Limit 4 and then I want to ORDER BY date ASC on that result, so just 4-games from the middle of the big table with ASC date order, any ideas? Just ORDER BY date ASC Limit 4 Does not work!

What I have: enter image description here

What I get: enter image description here

What I want: enter image description here

查看全部
dpp80346
dpp80346
2014/03/11 10:07
  • database
  • php
  • mysql
  • sql
  • 点赞
  • 收藏
  • 回答
    私信
满意答案
查看全部

2个回复