首页 > 这个SQL是函数还是触发器还是存储过程?

这个SQL是函数还是触发器还是存储过程?

set @num := 0, @type := '';

select type, variety, price,

  @num := if(@type = type, @num + 1, 1) as row_number,
  @type := type as dummy

from fruits
group by type, price, variety
having row_number <= 2;

【热门文章】
【热门文章】