MySQL怎样实现ORDER BY MAX(field)

By admin, 25 二月, 2015

SELECT * FROM
(
  SELECT *, MAX(field) AS max_field
  FROM mytable
  GROUP BY field_id
) t
ORDER BY max_field

其中,field,field_id应替换成具体的列名,mytable替换成具体的表名

标签

评论

Restricted HTML

  • 允许的HTML标签:<a href hreflang> <em> <strong> <cite> <blockquote cite> <code> <ul type> <ol start type> <li> <dl> <dt> <dd> <h2 id> <h3 id> <h4 id> <h5 id> <h6 id> <img src>
  • 自动断行和分段。
  • 网页和电子邮件地址自动转换为链接。
验证码
This question is for testing whether or not you are a human visitor and to prevent automated spam submissions.
请输入"Drupal10"