如下Sql语句
select top 15 * from view_Claim_Main
where Subject like N'%A83F622AAAAAA0340%' or SN like N'%A83F622AAAAAA0340%' or(Guest_Type='1' and Guest_ID in(select Dealer_ID from dbo.Dealer where Contact like N'%A83F622AAAAAA0340%' or Title like N'%A83F622AAAAAA0340%'or Tel like N'%A83F622AAAAAA0340%')) or(Guest_Type='2' and Guest_ID in(select Customer_ID from Customer where Name like N'%A83F622AAAAAA0340%' or Company_Name like N'%A83F622AAAAAA0340%'or Mobile like N'%A83F622AAAAAA0340%' )) order by Create_Date去掉 Order By Sql语句可以执行成功,加上Order By Sql语句持续执行,无法返回结果。
请问这是什么原因造成的???
select top 15 * from view_Claim_Main
where Subject like N'%A83F622AAAAAA0340%' or SN like N'%A83F622AAAAAA0340%' or(Guest_Type='1' and Guest_ID in(select Dealer_ID from dbo.Dealer where Contact like N'%A83F622AAAAAA0340%' or Title like N'%A83F622AAAAAA0340%'or Tel like N'%A83F622AAAAAA0340%')) or(Guest_Type='2' and Guest_ID in(select Customer_ID from Customer where Name like N'%A83F622AAAAAA0340%' or Company_Name like N'%A83F622AAAAAA0340%'or Mobile like N'%A83F622AAAAAA0340%' )) order by Create_Date去掉 Order By Sql语句可以执行成功,加上Order By Sql语句持续执行,无法返回结果。
请问这是什么原因造成的???
分析结果 Command(s) completed successfully.
order by Create_Date
后面加个desc 看看是否有结果?
为什么??
from
(
select top 15 * from view_Claim_Main
where Subject like N'%A83F622AAAAAA0340%' or SN like N'%A83F622AAAAAA0340%'
or
(Guest_Type='1' and Guest_ID in(select Dealer_ID from dbo.Dealer where Contact like N'%A83F622AAAAAA0340%' or Title like N'%A83F622AAAAAA0340%'or Tel like N'%A83F622AAAAAA0340%'))
or
(Guest_Type='2' and Guest_ID in(select Customer_ID from Customer where Name like N'%A83F622AAAAAA0340%' or Company_Name like N'%A83F622AAAAAA0340%'or Mobile like N'%A83F622AAAAAA0340%' ))
) t1
order by t1.Create_Date
where (Subject like N'%A83F622AAAAAA0340%' or SN like N'%A83F622AAAAAA0340%' or(Guest_Type='1' and Guest_ID in(select Dealer_ID from dbo.Dealer where Contact like N'%A83F622AAAAAA0340%' or Title like N'%A83F622AAAAAA0340%'or Tel like N'%A83F622AAAAAA0340%')) or(Guest_Type='2' and Guest_ID in(select Customer_ID from Customer where Name like N'%A83F622AAAAAA0340%' or Company_Name like N'%A83F622AAAAAA0340%'or Mobile like N'%A83F622AAAAAA0340%' ))) order by Create_Date