62,016
社区成员
发帖
与我相关
我的任务
分享
select * from (select row_number() over(partition by list.productName) as Sort, list.productName,list.id,list.prosort,list.proShowImg,list.mark,icon.iconPath from
tb_icon_type as icon,
tb_product_list as list
where list.proIcon = icon.picon) as product where product.Sort=1
select list.productName,list.id,list.prosort,list.proShowImg,list.mark,icon.iconPath from tb_icon_type as icon,tb_product_list as list where list.proIcon = icon.picon and list.id=(select max(id) from tb_product_list where productName=list.productName)