Hy_164274021的博客

mysql 分组取前几条 set @num := 0, @type := ”; select * from ( select id,type, data, @num := if(@type=type, @num + 1, 1) as row_number, @type := type as other_type from test c order by type, data desc ) ...

建表语句： CREATE TABLE `trade_params1` ( `ID` int(11) NOT NULL AUTO_INCREMENT, `PERIOD` int(11) DEFAULT NULL, `THEDATE` date DEFAULT NULL, `DAYCOUNT` int(11) DEFAULT NULL, PRIMARY KEY (`ID`) )...