显示平均折扣率最多的十条数据
MSSQL; SELECT TOP 10 * FROM TABLENAME ORDER BY 折扣率 DESC
mysql :SELECT * FROM TABLENAME ORDER BY 折扣率 DESC limit 10
SQL用row_number+where,FR用条件属性就可以
sql可以先按折扣率order by升序排序,再加top 10 这样去前10条数据
SQL排序后