Home  >  Article  >  Database  >  关于mysql中order by与group by的问题

关于mysql中order by与group by的问题

WBOY
WBOYOriginal
2016-06-06 09:39:56992browse

mysql

select * from (select * from t2 order by gid,col2 desc) as t group by gid

这条sql语句执行完之后,为什么gid的排序是增序的???

Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn