摘要:
1、Not in --两次Rep_InsuranceStandard表查询,效率慢 select top 10 * from Rep_InsuranceStandard where DisplayOrder not in ( select top 30 DisplayOrder from Rep_I 阅读全文
摘要:
select distinct sp.ID,sp.Name,sp.No,sy.Name as CityName, count(emp.EmployeeID) as EmpNum from Sp_ServiceProvider sp inner join Sys_Area sy on sp.Regio 阅读全文