摘要：今天做在写SQL时候发现有需要优化的SQL 语句，特拿出来和大家 分享一下：查询一SELECT SceneryIdFROMTableBcstbcstWITH(NOLOCK)WHEREbcst.PayMode=1ANDSceneryIdNOTIN(SELECTSceneryIdFROMTableBcstbcstWITH(NOLOCK)WHEREbcst.PayMode<>1)查询二SELECTDISTINCTbcst1.SceneryIdFROMTableBcstbcst1WITH(NOLOCK)WHEREbcst1.PayMode=1ANDNOTEXISTS(SELECTScene 阅读全文