select top 10 cname from pricelist where cname LIKE '%"&keyword&"%' and cname not in ('"&keyword&"') union select top 10 Number from pricelist where Number LIKE '%"&keyword&"%' and Number not in ('"&keyword&"') order by len(cname)
这句话提示错误,如果要最后出来的结果安装列(cname)的字符长度排列应该如何?
谢谢!
这句话提示错误,如果要最后出来的结果安装列(cname)的字符长度排列应该如何?
谢谢!
(
select top 10 cname from pricelist
where cname LIKE '%"&keyword&"%' and cname not in ('"&keyword&"')
union
select top 10 Number from pricelist
where Number LIKE '%"&keyword&"%' and Number not in ('"&keyword&"')
) t
order by len(cname)
union
select top 100 percent * from (select top 10 Number cname from pricelist where Number LIKE '%"&keyword&"%' and Number not in ('"&keyword&"') order by Number) t
union
select top 100 percent * from (select top 10 Number cname from pricelist where Number LIKE '%"&keyword&"%' and Number not in ('"&keyword&"') order by Number) t
order by len(cname)
(
select top 10 cname from pricelist
where cname LIKE '%"&keyword&"%' and cname not in ('"&keyword&"')
union
select top 10 Number from pricelist
where Number LIKE '%"&keyword&"%' and Number not in ('"&keyword&"')
) t
order by len(cname)
select top 10 * from(select cname from pricelist where cname LIKE '%"&keyword&"%' and cname not in ('"&keyword&"')
union select Number from pricelist where Number LIKE '%"&keyword&"%' and Number not in ('"&keyword&"')) t
order by len(cname)