Home >Database >Mysql Tutorial >[转] mysql分组取每组前几条记要(排名)
[转] mysql分组取每组前几条记要(排名)
- WBOYOriginal
- 2016-06-07 16:27:211055browse
[转] mysql分组取每组前几条记录(排名) ? ? ? ?参照这篇文章http://www.cnblogs.com/JulyZhang/archive/2011/02/12/1952213.html，拿出每个分类中的前几记录，写成的mysql如下： select a.id,name,type from adpos a where 3 (select count(*) from tablename
[转] mysql分组取每组前几条记录(排名)? ? ? ?参照这篇文章http://www.cnblogs.com/JulyZhang/archive/2011/02/12/1952213.html，拿出每个分类中的前几记录，写成的mysql如下：
select a.id,name,type from adpos a where 3 > (select count(*) from tablename where type = a.type and id
? ? ? ?mysql居然不会支持top ,比如select top 3 id from table order by type,id,就不行。
? ?
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
Previous article：MySql服务器系统变量和状态变量介绍Next article：MySQL-Python安装问题小记