34,838
社区成员




declare @t as Table
(
ITEM_CODE nvarchar(200),
ITEM_NAME nvarchar(200)
)
insert into @t
select '20181024001','压条'
union all select '20181024002','压条'
union all select '20181024003','压条'
union all select '20181024004','压条'
union all select '20181024005','压条'
union all select '20181024008','压条'
union all select '20181024009','压条'
union all select '20181024006','压条'
union all select '20181024007','压条'
union all select '20181024010','压条'
union all select '20181024011','压条'
SELECT top 20 ITEM_CODE,ITEM_NAME
FROM @t
--WHERE [ITEM_NAME] LIKE N'%压条%'
ORDER BY [ITEM_NAME] ASC
SELECT ITEM_CODE,ITEM_NAME
FROM @t
--WHERE [ITEM_NAME] LIKE N'%压条%'
ORDER BY [ITEM_NAME] ASC