问一个select语句

[cagecn]

要求：按照字段x分类，即group by x
得到的结果中，x字段中，相同的不超过5个

这个语句用在文章系统中，x是文章的目录id
现在取出每个目录中新的5篇文章

[loveflea]

用个循环吧！这样简单点！

[xiaosq2000]

select x
from table1
group by x
having count(*)<=5

[cagecn]

错了是order by

SELECT *
FROM `article`
WHERE cateid
IN ( 7, 12 )
having count(*)<=5
order by cateid;

一个结果也没有

[lehool]

不明白的意思！把表结构发出来。

[lehool]

select x as a from table1 group by x
while
SELECT * FROM `article` WHERE x=a order by cateid limit 5;
用循环吧！一条语句实现不了。

[cagecn]

CREATE TABLE `article` (
`articleid` int(10) unsigned NOT NULL auto_increment,
`cateid` int(10) NOT NULL default '0',
`posttime` int(10) unsigned NOT NULL default '0',
`author` varchar(50) NOT NULL default '',
`title` varchar(100) NOT NULL default '',
`description` text,
`clicktimes` int(10) unsigned NOT NULL default '0',
`rating` int(2) NOT NULL default '0',
`votes` smallint(6) NOT NULL default '0',
`ipaddress` varchar(16) NOT NULL default '',
`commentnum` smallint(8) NOT NULL default '0',
`published` enum('y','n') NOT NULL default 'n',
PRIMARY KEY (`articleid`),
KEY `postid` (`articleid`),
KEY `published` (`published`)
)