各位大牛问个查询产品表分类的问题

[禁用F3]

如何查询产品表Type字段不同的值的数据各查询10条？同时带一个产品名称的模糊查询。

[哋岼線]

吧你的需求贴上来。这样讲很难帮忙你解决

[双鱼星星]

需求不明确啊

[pengxuan]

给个表结构或数据，以及你想要的结果，把问题表述明白

[tomyuansir]

declare @A TABLE(type1 int,name varchar(2)) insert into @A select 1,'a' union select 1,'b' union select 1,'c' union select 1,'d' union select 2,'b' union select 3,'b' union select 2,'d' union select 3,'d' select ROW_NUMBER() over(partition by type1 order by type1),* from @A order by type1,name

[tomyuansir]

declare @A TABLE(type1 int,name varchar(2)) insert into @A select 1,'a' union select 1,'b' union select 1,'c' union select 1,'d' union select 2,'b' union select 3,'b' union select 2,'d' union select 3,'d' select * from ( select ROW_NUMBER() over(partition by type1 order by type1) id,* from @A )t where id<=10

[等不到来世]

select a.*
from 产品表 AS a,
(
	select id,rn=ROW_NUMBER() over(partition by [Type] order by ProductName)
	from 产品表
	where ProductName like '%香蕉%'
) AS b
where a.id=b.id and b.rn<=10