冰雨战士

摘要： -- mysql分组排序取前N条记录的最简洁的单条sql。use test;drop table if exists test;create table test ( id int primary key, cid int, author varchar(30)) engine=myisam;insert into test values (1,1,'test1'),(2,1,'test1'),(3,1,'test2'),(4,1,'test2'),(5,1,'test2'),(6,1,'test3' 阅读全文