select distinct list.productName,list.id,list.prosort,list.proShowImg,list.,icon.iconPath from tb_icon_type as icon,tb_product_list as list where list.proIcon = icon.picon group by list.productName,list.id,list.prosort,list.proShowImg,list.,icon.iconPath我现在有两个表 要实现的是 怎样根据名称相同的产品 就去除重复的产品 这样查出来用distinct是不行了 请各位大侠帮帮忙
换这个试试。
select list.productName,list.id,list.prosort,list.proShowImg,list.,icon.iconPath from tb_icon_type as icon,tb_product_list as list where list.proIcon = icon.picon and
list.productName in(select productname from tb_product_list group by productname)
list.id 最大的项吗
select list.productName,list.id,list.prosort,list.proShowImg,list.,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)
from tb_product_list as a
where not exists(select 1 from tb_product_list where productName= t.productNameand id< a.id)
再 join
(select iconPath from tb_icon_type where list.proIcon = picon ) as iconPath from tb_product_list as list where list.id=(select max(id) from tb_product_list where productName=list.productName)
select * from (select row_number() over(partition by list.productName) as Sort, list.productName,list.id,list.prosort,list.proShowImg,list.,icon.iconPath from
tb_icon_type as icon,
tb_product_list as list
where list.proIcon = icon.picon) as product where product.Sort=1