drop procedure if exists market.app_get_list; delimiter // create procedure market.app_get_list(in orders varchar(20), in type tinyint, in offset int, in rows int) begin declare done int default 0; declare pack varchar(40); declare packages cursor for select distinct package from market_app order by orders desc limit offset, rows; declare continue handler for not found set done = 1; open packages; repeat fetch packages into pack; if not done then select * from market_app where package = pack order by versioncode desc limit 1; end if; until done end repeat; close packages;end// delimiter ;

现在参数orders不起作用，麻烦懂的人帮忙修改下，谢谢哈。
回复内容： drop procedure if exists market.app_get_list; delimiter // create procedure market.app_get_list(in orders varchar(20), in type tinyint, in offset int, in rows int) begin declare done int default 0; declare pack varchar(40); declare packages cursor for select distinct package from market_app order by orders desc limit offset, rows; declare continue handler for not found set done = 1; open packages; repeat fetch packages into pack; if not done then select * from market_app where package = pack order by versioncode desc limit 1; end if; until done end repeat; close packages;end// delimiter ;

现在参数orders不起作用，麻烦懂的人帮忙修改下，谢谢哈。