SQL学习之高级数据过滤

时间:2023-03-08 20:05:32
SQL学习之高级数据过滤

一、高级数据过滤之IN操作符

IN 操作符用来指定条件范围,范围中的每个条件都可以进行匹配。IN取一组由逗号分隔、括在圆括号中的合法值。代码如下:

select ItemId,ItemName,CheckValueNum,CheckValueString,ResultLevel from T_Check_InfoDetail

aaarticlea/png;base64,iVBORw0KGgoAAAANSUhEUgAAAi8AAADQCAIAAABA7Rb2AAAgAElEQVR4nO1dTW8bO5blL/Kmg4d6/hnOroEsRjL0B4KsG8hqWnYABzCyfitvBhPLHsD73mUhIBh/bQxMd/prMquXpGPJ9nPgWUgqlUjey8siS8WiDnEglCgWP46u7tEtqXjVEwoKCgoKSttF/cd//hcAAAAAtAvVqNZ9+/at0f6FJZFpoGRcYGN8AT9eJVe6vn37Nv78kQLUCAUlQoGN8QX8eJVc6WpTjb5+/dpo/8KSyDRQMi6wMb6AH6+SK11fv36FGiUxDZSMC2yML+DHq+RKV2JqdHOwvX1wU68781xZb/GnoSonh3SFkkuxuo+bg221KIOzuqZiOetsMOtwZaSVCuJEdpQmrbrz/KxO1+grcrG7LLVSas6hrhf17tZW2lSjL1++6FWzSccyO1k/8aeh1PKTCzVCsdnYqns/Gyg1OIjlbfU6uw16q1GDVt15fp7OBuV0Z9rWkFt/enpiXFb4WKbrW6MaffnypTU1+vXXX/WqNtSoiWkcDBbfTaBGKBYbE/hIYbGetVJJ9OurRk1adR78NKQ9ZiFd1vL52aBedNSqGv3666+cGv322+P07qEJPD7++N/P/6f3f/WmKHb7hVJKqeLN5axmHnr+vHe10qDYP92bH1wvztVOWXSy/mlUJ1O8ubx7GPWXQXT/xNVDdaxm+AfWBouNleZRxdWboniz168YyZ3VGE77uiHNujrtLw3+eq9YtOcssGKod9ZP0GonmlWb5zJWnTc/d9d7RXWl13ul99CciWMVIS6rciI91cv9n+fj7F9P2XdQrXqwlbE0Z1i1k2Wl5jBF6+LU6OG3x8n0vgk8Pv74xz//V+//cr8o9i9mj9P7yfR6WBTDy9WXVDG8vJ9UD2aN5wfXw0L1RveT6f1ktKvm/ax/GvejvuqNKvVm5/YejLGa4R9YGyw2Zn1nL/cLtTBd0hgq5j096aliOJrVn/TUouX0fjK9v9grir3r6oE+um7krAVardo8l/lc5M3P9H4yvR7OHbDhEKo19lVoNZ50LciplN3RfEraVE96s5cu9wu1O7K+g/ZVl2NZlj/qq5JM1T+xO0zZutpRox8/fvz9H/90yIBOcWlbls8J+QlpZRqzDwPViVavzV8b69KPWCA1WGyM8rYW504YXvWsxddsW2+rfsG0QMmgl4RVU75sav04ZM1PtefZl2C5g4rosuZPF/JmmepcMucCXEONOPNYkCl5X4h1sWr08Nvt5K4JPP748be//1Pv/2K/KPbPZ4+zp6p/bDZgDsqn1ZfWP43J3e3k7nxYFL1+UeyfT056qhheEJ1r89fGAjoOm41dDYuFPZQwTZcxvGqN6h9ProaF6o3u9CFGZXvCAiWDTgirtp5Lfxxy5mcFJz3VP5Y7qIguq3w66qveicVxLXDcU6o6SeeqdT61DlfJlLwvxLoSVqOqDc1W6JaB5Snnw0JFUaM60yjtUqm5Gi3enlFfcZ9bY6xm+AfWBquNrRrnSU+p3tB0AaYxVL3q8kqU1QWcD4uiKIrh1aKx1QKNeqsFhlp15vycDwvVO7mVUGFx9KsdRlGj+bRtjmsuujO9J1bNCaTdQZ0PC6XUgkzaYbrWxanR/cNv32+nTeDx8cenv/5d7/9876di7/x21FNKqf772+n3+bFSqvjjednAdTA/o5jXtDKN2+n32+n5sFDF3vnsYBm57p1zJ66O1Qz/wNpgt7FVk+gdr1oOZwxljX7W+bBYsZnzvZ8qTykLXNYvPy/GoE6rnp3r+jhky8/t9H056orH6L/XqLCuonRZs6Fr0KXzfPnHQvWOLVMtl/PT8PI7+Q5WXF91bkqp3sjuoFbJJB2ma12cGt3dP/zr+6QJPD7++MunvzXXf7emAWQM2Bj4keJ9T/VGm0nXbF2sGt09fPvXbRN4fHz881/+2lz/3ZoGkDFgY+CHxfG/VYKyf//vDaVrti5OjaZ391+/fW8Cvz0+/s+fPzXXf7emAWQM2Bj4AV3CdXFqdIWCgoKCgrKWwu/F0GB5eHhotH9hSWQaKBkX2BhfwI9XyZWuh4cHTo2+bEBRSuERj2t4REFBYQojRXM1CtwujynO4deDL1++vBv/GQCaQyKmnizAD+iCGn0cf/6olGrdWwF5QynVup2njERcQVeQJV1QozkLrXsrIG8kYurJAvyALqjRx7E4NpI0Y9ooutQYiG+p1VubSdr4zgdgOGzdzlNGIq6gK8iSrhA1qpvNSaZGb18sXPWLw5AaIQu8H3Hqh9Vxl8ezA6FyeLUUnh6oRs5XASdoUz/cWZrV1ssP9c2408jSvbZH1+GOev627UnGXpRdjcoM7I2p0YdXW89eHX/+OP58+vLZ1ssPoprj11uLT+/py2dq50jKgtARmwflU6diUW3Klvyr2mTk/Zijm+t6Z9NLfsIK4uQJRcZGhuMwTb1tN5GCJwJkdJ2+fDb7gG6KGs1Kk7HR0fNquLNzJKup9HD8emvr9amcBd6PyH2x6da1l/gT+WNJh06NeWeIk3U4+WwBCQRfvGjjb9tNpOCJAB+68o2NiGTkp321OwrL0EwNX9WS2bGkptJDzNiId8HyGIJv46tGWr1VRUzh5LWKHxEIARkbfXi1tTCDmQ2zhp0toEZR6cpXjYj0r4uMtgFoSI2OX28p7fumiwXGiThlxunHrX7ffCrRM77xO1ego/Vg7c05H2r5AAPuMsDyupzaOYIaAeF0QY3SUCNfKRqzsZHVub8Ta4nWgGrpNRA/VWYC72x6JnSmkJ9AKMF/6gRBf7aAGkWlK2M1sqd/rSQNrIvovxvVkKJxWGzEuHWrkCgiXhGqkbU3yblme2tLSvygRoGQeNu59uB3IyCULqhRRDWq9Z+68dHzev8kEbpaPmRhFKt6SjUY0rRB0onZGzMx81xKn6xdaa86pwQwUERsVPkj6OGOIgy7bTeRgicCfOjKV42IZOSj3jzhbn3Evd9o+VQptfhNWMgC40RMl80fUw2ornhFsTZ+Z1Mjr374rphxgXqQmHppsbjfCAijK181ai7lbSImyLhaxkebYkOFNZq7Nw+sgzIj8ppkTsDaM9WbdVCoUSAU9mJgkYgr6AqypEumRo2lvE2EUyo2YvSGaUmdbj2w9mYOR0U81d6sGql1aE6PElFm7dScAQaJmHqyAD+gS6RGzaW8TYRT+FagaSA24pGIK+gKsqRLpEbNJZ1NhFPs4Q00jURMPVmAH9Al3IuhqZIIp4iNgKaB2IhHIq6gK8iSLpEabUJRCaSpxmPejygoKHxxq1HYzqi1dk1NTJMBIBCwMfADugIXBTUCgAiAjYEf0BW4KKgRAEQAbAz8gK7ARUGNPmq/P/M/R4f8WG2e6+yNaiCZs3xd+AU+HImYerIAP6CrphqdDRb3QIbl22OGD8k7/vaFx7ZAThZmvljZCtXS2glVqDbWrph+ysZCVVubygJj1sY2cB8gL34AL7q6a0511OjmYHshQpXDuGpUb9fU8lyfTep4FuQuXtMV4dBM//yg1HCUPlnFTztm+mFEFJDAw9Tbnmpa/ABedHXZnEKv1N0cbG8f3MRXo/qZyE9fPtvaeeGXFYaaBi8V1pZ8De/WzXpeV6xdOTXG7NYqUfySoUa+8DD1tqeaFj+AF11dNieRGhGZyB+md9d7heqfpJSJ/Oi5enHom6OMUSNGCaqVzOkOftkQh2nDnMhMgNcqsw0QC3JTb32qSfEDeNHVaXMSqRGR+/X+Yq9Qxf5FQrlf5/uox1KjOQUC70xFKnwDrVlVHsxHbTJ8J2Zj6+lMV8yEzdUBTmTpPtbAD+BFV6fNqb4ahUtRdDUqayKqURNu19on4/QpsaE6d0pdtVnInAE5snQfa+AH8KKr0+YkUyMj9+v5sFDF/nlY4tfYmchPXz5bccRe2fbsi1+VBCo+EAYQyghQnMeUGvGTEXZobSmZM1ADWV7oXwc/gBddXTanWmo06qvgHOSNZCJfnB73Sp3OiPiHFqfqWF1/RNngp2pGS3y3lMoCEmT5J6h18AN40dVlcxKpkZaJ/H1vxTH9NLxMJBN5iYZ+N3IqBHWiWUm9ZDp9Sh7MifHHztOdalTPwoAZsrxBZD38AF50ddecRGqUfSZy/kpdecwcUIXqzXxqDj0WKB81inUCVFeU5DAqBfgiEVNPFuAHdMnUaAMykQtbOl28tZ4RHka0TOUw9c98ysRJlNhYRdQ8l9c5gEcipp4swA/oEqlR9pnIE5kGkDFgY+AHdAUualMykbc+ByBvwMbAD+gKXNRGZCJPZBpAxoCNgR/QFbgoZFBGQUFBQVlHcatR7U1R6++ampgmA0AgYGPgB3QFLgpqBAARABsDP6ArcFFQIwCIANgY+AFdgYuCGknhdZeos5nzxli+paSNcCZAFCRi6skC/ICummpUZiIPS0QePxN5WeO1XSAzDeuNn9bbPwPViBmoOhw1Ll/JzwqCtAbQNna4s3yTO7ax2Fr4AWrQNc+t0/o8oy7KqkZnAzVP+Ho2CNMjcvh6u6YePVfzGr83Q/hJkEQYVhWx1tQYiNInUyDNY+XaW8HaDxALrBp1z3GskR/Ai64ylUH3jCrwSl1gIvImMpGXb4nH18xYasQrDa9Y1tO1GqfGjA1xskpUPS0EQiD44rXRgBpFpauTX3FEakRmIr96U6jdUd005I1kIp/hw6utNcZGTFxCnc4cS+TEHNTa0pwJlKYtcGq0eLu7lRttTfwAdejKV43I3K9K9UYJ5X4tj1W8341WuJBliKAueUnUSF5pBjpa7GVOhgnOrM2AiOAuAywvOHcsPdo6+AHq0LVhajSZ3k+m18MiSJCaio08P9gRfzdimgljI+tj+apVM7SWvqIC+VkDJDbWudTRa+YHENOVsRoZmcirKcmL4VUamchXevD6YCeiRqWoaJJjRj/WY0bDrBOj6oEmADUK5wcQ07UxanQ+LFTv5HZydzu5GhaqN0olE/nx662FPrUcG1ERjDVqsXbrrDQb8NGSeYoZS+EyXXNgLgMsjPZwB//wBuLQla8aaZnIq8nIQ9KQN5GJvKyJmIl8yUXd2Mh6YU17qlxFMop5TAVMZhugUUhMfWMDI54fwJ+ufNVoYzOR61yEXamjXvWKjZgghlEjs0NGpYAmkIipJwvwA7pkarSpmcgl8UrZ0npsdmj2L2nJj2L2w8Rb1nN5nQPCkYipJwvwA7pEaoRM5AAQCNgY+AFdgYtCJnIAiADYGPgBXYGLQiZyAIgA2Bj4AV2Bi0ImchQUFBSUdRS3GtXfFbX2rqmJaTIABAI2Bn5AV+CioEYAEAGwMfADugIXBTUCgAiAjYEf0BW4KKgRuYWBL+T94I6f/JCIqScL8AO6gtRomQO2ATVKJBP52FONmNtIfftp3TiAiHB90la2cpGYembI0r0mQFeXtggKUKObg23VmBrV2yO1mUzkTlFhtjmgThTuiYD9EbIBbWNG6mjJlsFtL2eN/AD16OpeSvLaanRzsL09GITlIQ/MRF5pb8tvFC0TuaYHlDAwaiRRLIRKecMjNvI0/jwANWqGruxiI0sm8pNd1T+93P+52L+unYY8MBN5pb2RPyJeJnJTLbRIRWtgPmotTV2B0mwC5GrkafyZAGrUDF3ZqZGR+/Wkp3ZH0/uLvaLYu24rE3m18eIC3eJpvN+NrGo0pi+7UWqkRVfmJThcqcsbUKMwfoB6dOWuRqUIpaBGmhQtECfbnlVaeH3i1UguKpCfzAA1CuMHENE1/7fL8q8u+anRSu7Xq2Gx8p29tUzkpBTNX4qYidz5Sw+jTOZTqhOmHug68LtRGD9APboyV6OVlOQhUhSaifzoufZ3keYykVuFhG9A/T7ESJT2Ki7T5QQPNcJ/6oBodGWnRmYm8hnOh0WLmciXT5VSiyzOTWQipwRDq+HDI0kDsw2QDXC/URg/QD26slOjTc5ETmmP+bTG1TlrV1RoBXQaiZh6sgA/oEumRhuciVxYaX1Ju8hWyoxZxoZuWdsA3UUipp4swA/oEqkRMpEDQCBgY+AHdAUuCpnIASACYGPgB3QFLgqZyAEgAmBj4Ad0BS4KmchRUFBQUNZR3GoUsi9qzV1TE9NkAAgEbAz8gK7ARUGNACACYGPgB3QFLgpqBAARABsDP6ArcFFQIz/UuDGI2g3IvNmIuSfJOQ35bby+bWovfKOQiKknC/ADuuqp0dlg6QaD8u0xwwdmIvfaQEXy1lLelpGQUieU7b5Xs2drJXVMNXD2IK8xK3nJgSAx8DL18eePtj1durTLS0R+gAC6umQztdVocFZfgwRqVCsTeXO7ps65cHlbPnQw5aH6aJ5O1ZuV2rFEHU1d5JXSnK1wLGAGysZsRmvmkO5eVulY/AB16eqezdRSo5uD0AzkTjUKzUQeOaPEkg5aGHjHPbYpkPbo5dmFfp+ZsHPy1c6tEsXrDdSoComNrRotYiMgnK4u2YxIjfRM5FdvygxHiWYibyyjBOVhTW2w6gfzOCY8vtZA4uKdkqZ1rvXJaxXPA0BB+GW2YrRQIyCcri7ZjEiN9Ezko11V7F9M7yfT62GheqO0MpFba0JZELtjJhaRqBGvItVTmDZekzQlyip+lKrxJYqN5gGnjRlGCzUCwunqks3UUiNbVvJ0MpH7ShHPAhUcjOkYwnpK6Z15NWI6N4+tE5MoBKUZ5ny8RAXyw4D/pNmMFmoEeNO1aZnIY6Z/DfzdKIoU8SxI1Ihy8Vbl4NXIGWQ4lcacHjNz67F1buZ6nfVAFYyNEUYLNQLC6eqSzdRRo/NhoXont5O728lJTxXDi1QykVtqglmQqJGz0uyK8vjOfoSSw8sVpUbUq6buWtsz0ghwX7zsRgs1AsLp6pLNiNTIzET+vjf3OEllIrfmJg9hwRkNjMW/nVBdjWlvbvXsZp+8nDgbCF+tjkX1DwVi4Li0YjFaqBEQTleXbEakRpuciXzOQq2LYGYl780lQ1hdv1xdyhqr1DG98cJM6SJQIhFTTxbgB3TJ1GhTM5GvEMF68GozyUtaPGT2z4RH1lGsIRTVD6NklNhI+uHnvOFIxNSTBfgBXSI1QiZyAAgEbAz8gK7ARSETOQBEAGwM/ICuwEUhEzkARABsDPyArsBFIRM5CgoKCso6iluNYuyP6rlramKaDACBgI2BH9AVuCioEQBEAGwM/ICuwEVBjQAgAmBj4Ad0BS4KauSHGjfZaPceSW7coW4Y4jvRurLeWhRrUYCGREw9WYAf0FVXjcpc5GE5YJnha+UdP9xZet2tlx9ivrWUR5Z4f2W7h9TsmZIKJZArbSzJKuRq5HwVcMLL1MefP2p7uhBt8gH3GTx6bl372xeO3b8yJtbfnDqAemp0NljI0NlAhaSBJYeX7Jpq1tTdlEn4RcPpkZkGVgXS9IOSB7NbuagwT6n5VCfMKx8gB2VjokzkFlPPDfRn8HBHzffsX5GfD6+2ym39dLk6fXt0mjexHp6z7alGWNQCNjUKlCCJGkkySpg1y3ciMgtLOug95XjnPrYpkPYo8f5CRaR6MF+1ztw5ENTIFxIbIzOR29KpZAbOFVg+1Kcvn23tvJjTdfz61dsFObOiUZQfsR6es+2pRljUApZM5Jf7P6v+aUgC8iiZyC359z682lo4WfkG3iIWXD6a8vtmJ9TjmFAFsytKb5jGTLfUPIG4EKgRmYmcSXycDQSxYwVHz9WLQzEVGRIr95ytTzV8USUsuV8v9oqiv1vMXGD/pHbi18Dcrxbel1+jNPsLZkHssq31vA5VhYQqzoFMNeK1Squ0tuTL2mw0DzhtjMlE3mkXE8jP8eutrRfP598ylz8PP38rpiJLYqFGSzVSxf7F9H4yvR4WqjdKRo2IHkJYoAKIMR1nWE8pPTivRkznTAOqDd/MS1QgP4HgP2l8JvJOu5hAfirMzL9ilgxIqMiV2A1WIy0T+ahfZh9vMxM5e4V0nWpUttFCB6sS8GrkDEScqmOdDKOFXt0CtcHYmDsTeZd/DAjl5+j5qns9XPwTYV6Yj3nGxG7u70a6Gk1Oeqp/PLm7nVwNC9UbtZSJ3KipXGI+3In0D29hbMRXml0xUZSzH60BJVdms7FNgZgG5ii+ERVQgnMfzkzkXf6jVCg/Sx70y++Ob5xZE7u5/6kzM5F/P+7P3VJv1FYmcr4myr8YnBHD2P+/cKYrpzw+5f0pDWPkpOzEqluKlkZm2oAXKBsTZiLv7k0kgfyMP5P3G/FqlDexm3u/ETKRM2rEt9QqeY8vGcKpanznjBpRjSnxA7yQiKknC/ADumRqhEzk4ktVwpe0eMjs3yxm51QbZz/VOUjG4vsBJEjE1JMF+AFdIjVCJnIACARsDPyArsBFIRM5AEQAbAz8gK7ARSETOQBEAGwM/ICuwEUhEzkKCgoKyjqKW41i7I/quWtqYpoMAIGAjYEf0BW4KKgRAEQAbAz8gK7ARUGNACACYGPgB3QFLgpq5HHrq9erzpuH+PuE+BHlc8adQ+tBIqaeLMAP6KqjRjcH26t+sn42cmb4ejsDjT9/rJEBVq5G5p2h1gbasURphDJmNgtUI+erQBS4Pmk5bFfTJD+AF101s2CnvShnbHRzsF1fjIIykYsyDYexwAiG77HzVclTa7Rk1lgH0mqc6gjEBf1Jyyc9djP8AF501fSBKSBUjc4GQTnJyeGD8kfEjI20oMQqTvWUyToQpQ2UHFprnArKTwZq1AQ8vsx2OSlAY/wAXnTlGxtpmciXuHpTFG8uW8pEXmlPZhoOZMF06FQzSZBB6U31Va0xMxOqf37mUJq2IHcfnU6Y1hg/gBdd+aqRlvu1mgQ2JPFrYO7XamMq03AgC7zAWD27MAYyn1YPKK3iAx2tB743vqzfELMH1CiMH8CLro1To5Oe2h0FSFEUNeIzDUdhoaoE5qO1MVPpVCPmKa+LptgIlw/5WQOgRmH8AF50ZaxGeu7XCDnII2Qil2QajsGCqQGMJklCH6YBFamYY1FqxLQUCiHQBPC7URg/gBddm6VGV8OiGF4ESVFoJnJJpuEwFngF8lIjs8Ya31ibWcdiejbb81OlQi4gIjzcB/5TB4TSla8a2TORh+UgD89ELsw0HM6CFrWM66qRtT3fjzA2osYSThUKtAbgfqMwfgAvuvJVow3PRM7rgXKVauOxpxrxY1n7oYajOrROCYiOREw9WYAf0CVTo83ORG513FY94M+tVpq6IlE1q95YJ8P0aT2X1zkgHImYerIAP6BLpEbIRA4AgYCNgR/QFbgoZCIHgAiAjYEf0BW4KGQiB4AIgI2BH9AVuChkIkdBQUFBWUdxq1H9XVFr75qamCYDQCBgY+AHdAUuCmoEABEAGwM/oCtwUVAjAIgA2Bj4AV2Bi4IacXcCeY1ivSWoRhvnS0CCSMTUkwX4AV011ahMRh6Uay84E/n480dqSxWvvSaZaTidvnljKSVXcdVIMjcgHcQw9ZyRpXttj658dwayadEs/fjZIEyPyOElu6aaOXePni+29PZ7M6hpWAWGVxpFbJdgtnGqkdmMidLMKQFJgbKx49dbC8lZJI3ErqlAfbo2LRP5zcH2QoPOBnNdiqxGHpnIycQw8vDIeaXOWWlVGrOSiZ+0GquqIVTqLiTedm7AyCgBhNKVb2xkZCK/3it+3rt6mN6d9tXuqOVM5KuJYZZfKpU8TVm93420NtUDSo2sT81+zJegNF2HwNvOYyNk2wOC6cpXjSy5Xy/3C6WUKoaXrWcit/5utLXzwuNjHBIbWWMaRn6YQIcKlahKXiCBpOD8pJWpI6FGQDBdm6NGl/tFsX8xvZ9Mr4dFkCBFV6MSb1+kGxtpp5gDCacN+ekQeBurZjGGGgHBdGWsRqu5X6s5yAPzkcf93aiCxQ/CsVgQ/LOuesDLDxX3aKdQURQTXQHJgrGxqhSNPyMTORBO18ao0e2or4r983k+ctUbtZSJ3OB9+fckMkl5HRa8YqMxIUVmjVVLvIIqXKbrELgvXpqt4j91QChd+aqRmYn8fW/hAsPykXflfiPhRTbmFEknY0KHEBtlAMrGllatlFLzy8u43wgIoytfNdrwTORzIuioiLm8Zn3J+tR6OnUWJXhAskjE1JMF+AFdMjXa4EzkjAJJoh/rFTyzCNtoLZl+gNSQiKknC/ADukRqhEzkABAI2Bj4AV2Bi0ImcgCIANgY+AFdgYtCJnIAiADYGPgBXYGLQiZyFBQUFJR1FLca1d8VtfauqYlpMgAEAjbm5Ofp6RMgRJbmBDUSsQAAgYCNOflp3cV3CFmaE9RIxAIABAI25uSndRffIWRpTlAjEQsWXvwzt9a7H1bejH8JaBeJmHqygBpBjWqq0dlgfrtlSKo9Xo3q7QxE1NRkQdsIvNwHj7rhVPi0eqDd3Gr2bApMPTWy3i2L22bXBtcnLYIZdxqkGt38YVv97uCm8nT7DzdPn56efhmo358tWy6eLhuYp+QDsRp1yYpqqdEy/3hg6tfYmcjrZuGlWTjcUYttKz+82lp0S0kFE/eMiUxIYyNmUvSGC1Q/Eo2B5LQL2saimXGnwaqRUqWcQI2katQ9K6qjRpVE5E83B9vpZCKnawJYmOeTXUlRwevB2KY0Vnngy9gmb5Ia89j5FGgaiI2c/JBqtP2Hg4EanEGNvNSoe1YkUiM9E/nJrireXM5Tkqti/zqVTOR13wCehfkVwsrlQeWKjSTRCa8HVqWx9gA16gSgRk5+GDW6KRUFarThamRmIh/1Z76x6PWLYu86sdyvkdVo/OHVllpJMyO8GsYEQ9ZK66vmMRV4Mf045wY0DaiRkx9OjZ4+nc3CI6gR1IiSk1Ff5a5GhztK7bxe/mg0Fv/kUz025cFsxpxoVakasZFTtICGADVy8sOr0dPTL4NqkAQ1stFoXMjpkhXJ1EjL/bpEY7lfk/nd6O2L+Vtr/UMdI0u8hFQrGXngj2uoEfUUaBpQIyc/LjX6dHPwu+3B7xdP/3Swbfuv3cNXqnAAAAQ6SURBVGarkcCu0kUdNTofFqp3Mk9JrvrHdaUoeiby2m8AJ4qr/3Sq/pFh/FmPingXbw1EnKcwLZlwxxyLCpXWbHAbC6iRkx+nGj09/TJQy//XnZV/bXj69HT2ezX4xa49UKO231y5DfANHJnIe8f105A3kYm83htATONwR8tovviTtyZCS7JscY/5qlbJCIlQjZxtmKlCkNYDqJGTH4Eafbo5+N3y395PfzrYXnxgqn8Br36QBr9YatrWEqgRZQN8A2QiNxgRXA2jQhOJfpj9WGMd67k11AhYDxIx9WSBvRiaUaMuQaZGG5yJnKNmNYixCsbYFiGFx0bUWNYOxxUV5IcDmkMipp4soEZQI5EaIRM5AAQCNubkp3UX3yFkaU4iNUImcgAIBGzMyU/rLr5DyNKchHsxIBM5AAQBNubkp3UX3yFkaU4iNUJBQUFBQWm6uNWo/q6otXdNTUyTASAQsDEnP60HHB1CluYENRKxAACBgI05+WndxXcIWZoT1EjEAgAEAjbm5Kd1F98hZGlOUCM3C7Fu05Hcfyq/RxU3CXULiZh6soAaQY1C1Ggl8WuZm9wrGSwzfL2dgco2Kzv6BLDgdPrmfaaUXMVVI8ncgHTgY+qHO0sLWkllkjFINUIm8iA1ym5nIENEbhbbQy2UZ5kOtpoYNkCN6mUin+dp9X4PqGlYBYZXGkXsnmC2caqR2YyaiXVKQFKgbKzcG76yLW+XPEhEfmg1QibyGmq0GZnILbGR/TBAjWpllNByIMnDI+eVOmelVWnMSiZ+0mqsqoZQqbuQfJmdG/Dyi9cGgVMjZCKvo0YzdOmbjUiN9Ezkc5z21e7o7mF693C5/3OZj7x6vO5M5MvY6PTlM1VpE8RCjdiIUiPrU7Mf8yUoTdch/DK7czTbKn5e5DbcdfBqhEzkUKPxZy7360lP7Y6m95Pp/cXeMh959Xj9uV8Xl+C3dl5sRVQjptIa0zDywwQ6VKhEVfICCSQF5yft+PXW/LvU6pcqr19AuwuHGiETOdSoc2pU4u2LdGMj7RRzIOG0IT8dAm9jSyky6jckPHKqETKRS9RoYzORn/TKxK+j/jwb7OTuuOeRmzzu70YV+H2pdLMg+Gdd9YCXHyru0U6hoigmugKSBWNjlBSNoUZPyETup0YGNlCNLvaLYv98cnc7uRoWxfCinUzky78nrWQQD2XBKzYaE1Jk1li1xCuowmW6DoH74rVqq5V/2R3u4B/eyEQONVrAnon8++30++2op/rvjdzkqjdqMRN5Q/cbCS+yMadIOhkTOoTYKAM4Lq0syiwSKis3JDAaIxM51AiZyIUsjI1/K2j11afVA+tL1qfW06mzKMEDkkUipp4ssBdDM2rUJcjUaIMzkTMKJIl+TDVStiJso7Vk+gFSQyKmniygRlAjkRohEzkABAI25uSndRffIWRpTs5F/T/I1BulziRgcwAAAABJRU5ErkJggg==" alt="" />

现在我们需要检索ItemId值为0002和0004的行记录数据,

(1)第一种写法,通过or操作符

select ItemId,ItemName,CheckValueNum,CheckValueString,ResultLevel from T_Check_InfoDetail where ItemId='' or ItemId=''

aaarticlea/png;base64,iVBORw0KGgoAAAANSUhEUgAAAcgAAAA+CAIAAAAgfxwNAAAMGElEQVR4nO1dzW7bxhY+L1IkT+CVYUz9Bll0EWfbLC5laJtF0Ky6SVY3kgIoQJ4hG0G2ZAF+hi4EGJVlbwzcNm2a+q6iuNavZbgL/mg4P4dDciiK1Dn4YJCjmTNnvpn5OKIpDrTaPQKBQCBYBLTavYcs7ebmJlP/hrYhYZTGiE/ciJ9YVj66SFjJkhjxiRvxE8vKR1fmwvrt27dM/RvahoRRGiM+cSN+Yln56CJhJUtixCduxE8sKx9deQjrVXN/v3mVzJ1c1syb/TCAK5zGVTFNOROumvvgW/U0KS2KUqdV12GoplCCpiBaS5Y9WHh+wuFKviybenpCyBLGkFQxYrsNW+bCOhqNxCQ3JlujysyP/TAAVhNz+4RV5jOsVKdVgGrTlnCIaWq+Ywtrhj1YeH4eTqtBuK5MZ6RQDw8PyPRMX5c8zcshrF+/fhWT8hDWLMJoVv2r6PYJq8SnwXQ3NGWpUKLGb1xhzbIHy8FPRjIqm3Z6rs5Pq8nWrDkK693dcjpbZIHl8v7v6/+L/i/eMXZYYQAAwN4N3RRvvf99/SKUgTVO6t7BpV9WKOI7WX8YfDDs3XC26FRW31wq3SgPfF3Z8L++bg2oEBl+V69whKgbflIRSXNdnVRWnXtZZ35+jG2uU9SjJexE6EG5LNKD5eZndllnfEsv68FMESZORCvSTE+uoD7UYeN7r57G5RTtQQjP1lBdwsTnx8kqURAHrF3QavcWd8vJdJ4Flsv7v778LfofNhhrnLt/p/PJ9LLGWG0Y/ghYbTif8AduZu/gssbA6cwn0/mkcwien/WHMe9UwOlw6bJztQeprmz4X1+3KlsxbDDwu0nbcK4rp10HWK3jpncd8HNO55Pp/LzOWP2SP1B3JR8JwrayB+WyyBgoNz/ejPAkSxz8fIq6FUJKoukJvB12pqpJOu067kfDBoPDjrIH1a0O6lI0v1OBgEyodNXigLYrW2G9v7///NeXCEUTGQyGjmIaaCdALmG4Y13nREgX4hfqGsYjNl8o+NQJh0KnNCTzpfzFj8pbeIjLbJtUOtT0oG5aqru+1Pzwnt21i/lktDg9vVNfqRWheurvXUsSCCs2PHwyTfolDGi1e4vF3XgyywLL+/s/P38R/Z83GGsM3L/uKVSO5QzIQXDKf7T+MCaz8WQ2qDHmVBhrDCZdB1jtXONciF+oq1BQ8XlRY37bZQKRhsvd5+W5qDFwOjOxik6QX8O2SaW6HlSW1Xd9mfkJoetA5dh8MlqcnsFppwJOVzFJfRw7AHyQka0W+RQchsk06ZcwNkBY+SHiNiBa0VZFBjUGVoQ1SRjBsAPwhNVnv1MBbFpKdWXD/zq7NdwRXQfAqcmjWW44LxCrr7rK0TyoMcYYq134mZVsS+lKttP2YMn5GdQYON2xCRUKzQo7tCKsXtiqSepdP9xLl6bVmNarJ+OgxgDAJ1MvDhpAq92bL+5ux9MssFzef/rjs+h/UN9j9cG44wAAVI7G01vvGADY20GQIerAK8G8lFzCGE9vx9NBjQGrD9yD1deF+gArGK4rG/7X2q3h5jvHYZawhgcpYqlBjYX4GdT3uFMd26v01diQKo3sQbdsVNeXlp/x9CioNTQ7KkcCFcpWBNPTrTr59AxShm8ZOMeKUIPm7NWGt9oe5KY5HxsAOB31ZAyTqRUHDaDV7s3mi39uJ1lgubz//dOf2fkvVhilAfFJ/JjiyAGns4V0Qavdm80WN/+Ms8Byufzt9z+y81+sMEoD4pP4QXH8H26p/N9ft5EuaLV709n8281tFrhbLv/326fs/BcrjNKA+CR+iC4c0Gr3LsjIyMjI7Jn7y6sMbbFYZOrf0DYkjNIY8Ykb8RPLykcXtNq9UcYGABvyl4yMjGwN5glryjcSIDYajV433+aO0WjUvz4j2ALxSfwQXQjWIawAkLuwAkDuXJcJ5ZsJxA/RZRG0YiUkAfFJ/BBdCGjFGqbDIBuSB/SWoCI8p5CuzGaSJ248Lso3E+yC+NlyunBhTfpy2bCw6sTux2DvhX0nTUr6FauJFPKZ5WP3wFAEY+U0LJ5SWCM/FaDn88PBisKdl7+c9a/P3j/3E55/yGgcbxrKpxS50vXhAJ69zzvIWNAJa7DjjAVhVa9Yf/7hu8c/vGi+fd189eTxoyc/G6W8ePrI19NXTx7DbtXOilXQx75KkiLFV5cnyIl/KgRj7keuXW5XXyX9eMCAMoYKa3gO/PLTzu5Px9dn/euTl7ue1JYeJKyW6Dp5uesOxpIIq2tZrlire/widLdqlsJ5ePH00XdPX+W1YlVmwMUIl7zIIkhZZYqgxXJx82hlaPlcyaiPj8+Cher753DwMf9BvwaQsFqlq7ArVs3uLCcVOOyk28ZDt2LlZdE9NknhPNhcsa7o0AiZ4coOzxNXWIV0pSDK1wBcdvEazYEJq9/knTcn/euz4zc77oFwXG6QsFqlq7DCqtlEwN/2IAV0K9aUwvri6SPw7hKkXbGaKCafWedE/lQ+NZFmPHM/avkpeFB6i4xH1/zomfDxGay++MPBRxJWQnq6SFhVwgq2V6xxVRVfsSp1qm8si0IGXc5YFeGhIgH0VdJsOhTs/PNqBVdGSVgJqekqrrCqNxHgXsedFNbvsSZQ1ZQrVkShlJoImlWkobAqvZmUlfMrc+p0PCNhpXushNR0kbCqhBXsPRXwuroHsPdjTFVNdo9VFiBEfPki/BJVkDkTJ7I3JDC5rE5qla6ETyNDCqCbCcdvdnwZ/XDgPm5FTwUQ0tJVWGHV7M7ScbxdGZLD7nOsq1MAALDyVIBSffBjXQadK1wclZn7KmGN5Qd3hdRrAoTP4KnV4Fs/PcdKSEdXYYU1u30RNv+XV4jcyLqpW2wKyiUfKCtFasTlVQ5A6VnnTVmpLWElED9Ely+sme2LsOHvCkCkE8mpK648UHqTq9OtQ3lvSrkXHMrh6a4HSNt1MQco30ywC+Jny+nyhDW7fRE2f8VKSIDyzQTih+iyCE9Ys9uiYMNXrIRkID6JH6ILQfDLq6yMVqylRPlmAvFDdFnEOrZmGeW9IwvQvixkZGRrtHW8jzX3q0cpL4nE5yaD+NlyukhYCcQn8UN0WQYJK4H4JH6ILssgYT3r63+MZJI5Ht1mj8eaZDCJ2bxdcRu1Id26sSB+tpwurbCeVv3HxNO96hqhTP6lo0lKkB7rPUkmwmrykLz8aD3/kc50eZSuED/A/VhAGRieaPGCEatbtxDlU4q86CrocFIL61Vz39dT7tCusMrv5jBJCcqCNWE1VytBIk0pRn+Mj1Sqq04ntUodF44RP8j1IAafW/nKlRj8EGLRVdjhFH0r4Kq5v9+8si+s8tvkTFJ8ig+ex3uzpy4MXPWUOfEUXKHkdFwila4i5VJ2q1RbvMkJhXUrXxIYgx9CLLoKO5zwrVkW09llnUGlm2prFmXF8vuPTVICruO+MhkRVkTU+ESkeATFBj/tjxQ+Eye6nHKEkTEn5nM7X2ttzg8hFl3FHU74DgLz8zoD1jhPt4OAIWVmwuq9QMyWsHosGAiNbv2IZxCy8Uon/xWCwZ3ImZXFEVdIwHLrDPks7kywCxJWK3QVdzhhwppeVa0La5BiUVjTL98MfSL6pdNNnfNI1eazpYk5Lp/FnQl2QcJqha7iDiftDgKDGgPWGKTbPsDdQUBdd5J7rMEm456ZE21yKwBZtRku60BaNkYe64QVD8bQoTKnScyJ+SzuTTG7IGG1Q1dhh5NGWDsVSL0pS4SwpnkqwPatAJEU45uSkQKqVDGLCoiHKq9hcbe6C0YMPgv7b1y7IGG1Q1dhh5N6a5YjJzTH9mrDNFuz6OpO8xxrRvdYI8VOV1BO1H0k65dO6eTA8OPI4pHCaoXPgj54aBckrLboKuhwWsfWLLk3Euk55Vds5YHOdN7kU7nqvoGI62pRBqBzpVNPRHCT8Ukgfoiu/vVatmbJvZGxei5SrZTpiIYi+iuLoCzl8imyetXppvJ6IJfFJTsZn9sJ4mfL6VrH1iy5N7KUPUd8bjKIny2nax1bs+TeyFL2HPG5ySB+tpyudWzNknsjS9lzxOcmg/jZcrrWtDULGRkZ2fYYtNq93NWdQCAQygQSVgKBQLAMElYCgUCwDBJWAoFAsIx/AbpNiZa7k3WaAAAAAElFTkSuQmCC" alt="" />

(2)第二种写法,通过IN操作符

select ItemId,ItemName,CheckValueNum,CheckValueString,ResultLevel from T_Check_InfoDetail where ItemId in('','')

aaarticlea/png;base64,iVBORw0KGgoAAAANSUhEUgAAAcgAAAA+CAIAAAAgfxwNAAAMGElEQVR4nO1dzW7bxhY+L1IkT+CVYUz9Bll0EWfbLC5laJtF0Ky6SVY3kgIoQJ4hG0G2ZAF+hi4EGJVlbwzcNm2a+q6iuNavZbgL/mg4P4dDciiK1Dn4YJCjmTNnvpn5OKIpDrTaPQKBQCBYBLTavYcs7ebmJlP/hrYhYZTGiE/ciJ9YVj66SFjJkhjxiRvxE8vKR1fmwvrt27dM/RvahoRRGiM+cSN+Yln56CJhJUtixCduxE8sKx9deQjrVXN/v3mVzJ1c1syb/TCAK5zGVTFNOROumvvgW/U0KS2KUqdV12GoplCCpiBaS5Y9WHh+wuFKviybenpCyBLGkFQxYrsNW+bCOhqNxCQ3JlujysyP/TAAVhNz+4RV5jOsVKdVgGrTlnCIaWq+Ywtrhj1YeH4eTqtBuK5MZ6RQDw8PyPRMX5c8zcshrF+/fhWT8hDWLMJoVv2r6PYJq8SnwXQ3NGWpUKLGb1xhzbIHy8FPRjIqm3Z6rs5Pq8nWrDkK693dcjpbZIHl8v7v6/+L/i/eMXZYYQAAwN4N3RRvvf99/SKUgTVO6t7BpV9WKOI7WX8YfDDs3XC26FRW31wq3SgPfF3Z8L++bg2oEBl+V69whKgbflIRSXNdnVRWnXtZZ35+jG2uU9SjJexE6EG5LNKD5eZndllnfEsv68FMESZORCvSTE+uoD7UYeN7r57G5RTtQQjP1lBdwsTnx8kqURAHrF3QavcWd8vJdJ4Flsv7v778LfofNhhrnLt/p/PJ9LLGWG0Y/ghYbTif8AduZu/gssbA6cwn0/mkcwien/WHMe9UwOlw6bJztQeprmz4X1+3KlsxbDDwu0nbcK4rp10HWK3jpncd8HNO55Pp/LzOWP2SP1B3JR8JwrayB+WyyBgoNz/ejPAkSxz8fIq6FUJKoukJvB12pqpJOu067kfDBoPDjrIH1a0O6lI0v1OBgEyodNXigLYrW2G9v7///NeXCEUTGQyGjmIaaCdALmG4Y13nREgX4hfqGsYjNl8o+NQJh0KnNCTzpfzFj8pbeIjLbJtUOtT0oG5aqru+1Pzwnt21i/lktDg9vVNfqRWheurvXUsSCCs2PHwyTfolDGi1e4vF3XgyywLL+/s/P38R/Z83GGsM3L/uKVSO5QzIQXDKf7T+MCaz8WQ2qDHmVBhrDCZdB1jtXONciF+oq1BQ8XlRY37bZQKRhsvd5+W5qDFwOjOxik6QX8O2SaW6HlSW1Xd9mfkJoetA5dh8MlqcnsFppwJOVzFJfRw7AHyQka0W+RQchsk06ZcwNkBY+SHiNiBa0VZFBjUGVoQ1SRjBsAPwhNVnv1MBbFpKdWXD/zq7NdwRXQfAqcmjWW44LxCrr7rK0TyoMcYYq134mZVsS+lKttP2YMn5GdQYON2xCRUKzQo7tCKsXtiqSepdP9xLl6bVmNarJ+OgxgDAJ1MvDhpAq92bL+5ux9MssFzef/rjs+h/UN9j9cG44wAAVI7G01vvGADY20GQIerAK8G8lFzCGE9vx9NBjQGrD9yD1deF+gArGK4rG/7X2q3h5jvHYZawhgcpYqlBjYX4GdT3uFMd26v01diQKo3sQbdsVNeXlp/x9CioNTQ7KkcCFcpWBNPTrTr59AxShm8ZOMeKUIPm7NWGt9oe5KY5HxsAOB31ZAyTqRUHDaDV7s3mi39uJ1lgubz//dOf2fkvVhilAfFJ/JjiyAGns4V0Qavdm80WN/+Ms8Byufzt9z+y81+sMEoD4pP4QXH8H26p/N9ft5EuaLV709n8281tFrhbLv/326fs/BcrjNKA+CR+iC4c0Gr3LsjIyMjI7Jn7y6sMbbFYZOrf0DYkjNIY8Ykb8RPLykcXtNq9UcYGABvyl4yMjGwN5glryjcSIDYajV433+aO0WjUvz4j2ALxSfwQXQjWIawAkLuwAkDuXJcJ5ZsJxA/RZRG0YiUkAfFJ/BBdCGjFGqbDIBuSB/SWoCI8p5CuzGaSJ248Lso3E+yC+NlyunBhTfpy2bCw6sTux2DvhX0nTUr6FauJFPKZ5WP3wFAEY+U0LJ5SWCM/FaDn88PBisKdl7+c9a/P3j/3E55/yGgcbxrKpxS50vXhAJ69zzvIWNAJa7DjjAVhVa9Yf/7hu8c/vGi+fd189eTxoyc/G6W8ePrI19NXTx7DbtXOilXQx75KkiLFV5cnyIl/KgRj7keuXW5XXyX9eMCAMoYKa3gO/PLTzu5Px9dn/euTl7ue1JYeJKyW6Dp5uesOxpIIq2tZrlire/widLdqlsJ5ePH00XdPX+W1YlVmwMUIl7zIIkhZZYqgxXJx82hlaPlcyaiPj8+Cher753DwMf9BvwaQsFqlq7ArVs3uLCcVOOyk28ZDt2LlZdE9NknhPNhcsa7o0AiZ4coOzxNXWIV0pSDK1wBcdvEazYEJq9/knTcn/euz4zc77oFwXG6QsFqlq7DCqtlEwN/2IAV0K9aUwvri6SPw7hKkXbGaKCafWedE/lQ+NZFmPHM/avkpeFB6i4xH1/zomfDxGay++MPBRxJWQnq6SFhVwgq2V6xxVRVfsSp1qm8si0IGXc5YFeGhIgH0VdJsOhTs/PNqBVdGSVgJqekqrrCqNxHgXsedFNbvsSZQ1ZQrVkShlJoImlWkobAqvZmUlfMrc+p0PCNhpXushNR0kbCqhBXsPRXwuroHsPdjTFVNdo9VFiBEfPki/BJVkDkTJ7I3JDC5rE5qla6ETyNDCqCbCcdvdnwZ/XDgPm5FTwUQ0tJVWGHV7M7ScbxdGZLD7nOsq1MAALDyVIBSffBjXQadK1wclZn7KmGN5Qd3hdRrAoTP4KnV4Fs/PcdKSEdXYYU1u30RNv+XV4jcyLqpW2wKyiUfKCtFasTlVQ5A6VnnTVmpLWElED9Ely+sme2LsOHvCkCkE8mpK648UHqTq9OtQ3lvSrkXHMrh6a4HSNt1MQco30ywC+Jny+nyhDW7fRE2f8VKSIDyzQTih+iyCE9Ys9uiYMNXrIRkID6JH6ILQfDLq6yMVqylRPlmAvFDdFnEOrZmGeW9IwvQvixkZGRrtHW8jzX3q0cpL4nE5yaD+NlyukhYCcQn8UN0WQYJK4H4JH6ILssgYT3r63+MZJI5Ht1mj8eaZDCJ2bxdcRu1Id26sSB+tpwurbCeVv3HxNO96hqhTP6lo0lKkB7rPUkmwmrykLz8aD3/kc50eZSuED/A/VhAGRieaPGCEatbtxDlU4q86CrocFIL61Vz39dT7tCusMrv5jBJCcqCNWE1VytBIk0pRn+Mj1Sqq04ntUodF44RP8j1IAafW/nKlRj8EGLRVdjhFH0r4Kq5v9+8si+s8tvkTFJ8ig+ex3uzpy4MXPWUOfEUXKHkdFwila4i5VJ2q1RbvMkJhXUrXxIYgx9CLLoKO5zwrVkW09llnUGlm2prFmXF8vuPTVICruO+MhkRVkTU+ESkeATFBj/tjxQ+Eye6nHKEkTEn5nM7X2ttzg8hFl3FHU74DgLz8zoD1jhPt4OAIWVmwuq9QMyWsHosGAiNbv2IZxCy8Uon/xWCwZ3ImZXFEVdIwHLrDPks7kywCxJWK3QVdzhhwppeVa0La5BiUVjTL98MfSL6pdNNnfNI1eazpYk5Lp/FnQl2QcJqha7iDiftDgKDGgPWGKTbPsDdQUBdd5J7rMEm456ZE21yKwBZtRku60BaNkYe64QVD8bQoTKnScyJ+SzuTTG7IGG1Q1dhh5NGWDsVSL0pS4SwpnkqwPatAJEU45uSkQKqVDGLCoiHKq9hcbe6C0YMPgv7b1y7IGG1Q1dhh5N6a5YjJzTH9mrDNFuz6OpO8xxrRvdYI8VOV1BO1H0k65dO6eTA8OPI4pHCaoXPgj54aBckrLboKuhwWsfWLLk3Euk55Vds5YHOdN7kU7nqvoGI62pRBqBzpVNPRHCT8Ukgfoiu/vVatmbJvZGxei5SrZTpiIYi+iuLoCzl8imyetXppvJ6IJfFJTsZn9sJ4mfL6VrH1iy5N7KUPUd8bjKIny2nax1bs+TeyFL2HPG5ySB+tpyudWzNknsjS9lzxOcmg/jZcrrWtDULGRkZ2fYYtNq93NWdQCAQygQSVgKBQLAMElYCgUCwDBJWAoFAsIx/AbpNiZa7k3WaAAAAAElFTkSuQmCC" alt="" />

两种结果显示:IN操作符和OR操作符完成了同样的效果,但是使用IN操作符的效果更好!它的优点如下:

第一点:在有很多的合法选项时(就是需要判断的字段有很多的时候),IN操作符的语法更清楚,更直观。

第二点:在与其他AND和OR操作符组合执行IN时,求值顺序更容易管理。

第三点:重要的一点是IN操作符一般比一组OR操作符执行的更快(上面的例子中可能无法察觉,但是一旦查询的数据量大的话,就能看出来)

第四点:超级重要的一点就是IN操作父可以包含其他的select语句,能够更动态的建立WHERE子句。

二、NOT操作符

where子句的NOT操作符有且只有一个功能,那就是否定其后所跟的任何条件。因为NOT从不单独使用(他总是与其他操作符一起使用),所以他的语法与其他操作符有所不同。NOT关键字可以用在要过滤的列前,而不仅实在其后。代码如下:

select ItemId,ItemName,CheckValueNum,CheckValueString,ResultLevel from T_Check_InfoDetail

aaarticlea/png;base64,iVBORw0KGgoAAAANSUhEUgAAAisAAAEhCAIAAAAxv3eEAAAgAElEQVR4nO2dzW4bSZbv40UG3U+gTRmFLL1BL2bR8q4wXlzS4LYXBfdqgEJ7dZuSARnQA3jlzcVYlAbQvndeEDBGXxsBM+OZnh7fVblqrC+XDc2CZDIZcc6JExmRzMzgP/CHQAYjIyMOj86PkWTGMQ8PD//vn/4ZgiAIgtYsMyPQQ5Pll19+abR/ZenIMFAyLvAxucA+QSVXc/3yyy/TD+9mAoFQUJIV+JhcYJ+gkqu51k2gn3/+udH+laUjw0DJuMDH5AL7BJVczfXzzz+DQCgo6Qt8TC6wT1DJ1VwdINDV/vb2/lW97txjdb2lH4apHBzTFUouhQwZV/vbZlFGJ3VdhTjqZDTrcOVMKxXMgeJZmvTq3ttndbhOX4kLHbLMSqk5hrpRNLhbqqybQB8/frSrZgNN5Wq6ftIPw5jlfysIhEL52GpIPxkZM9pPFWHtOtoHgwnUoFf33j4PJ6NyuDOeNRTKHx4ehJAVfy439K2RQB8/flwrgX766Se7qg0CNTGM/dHiMwgIhEL4mCIuKgt51Eol028ogZr06jzs0xBv3MKGrOXzk1G9VVCrBPrpp59sAv3665fbu89N6MuXr//94f/b/V+8KIqnw8IYY0zx4nxWM19Wfrd7sdKg2DvenT+4XBxrHbLoZP3DqA6meHF+93kyXC6Qh0e+Hqrnasb+0NpE+FjpHlVdvCiKF7vDipPckc5wPLQdadbV8XDp8Je7xaK95IEVR70j/4NWO7G82j1W8Oq87XN3uVtUZ3q5W0YPK5h4ZhETsioH8kM93/tufp69y1vxHTSrEWzlXFYwrPrJstIKmKp52QT6/OuXm9v7JvTly9f/+tt/2/2f7xXF3tns7+39ze3luCjG56svmWJ8fn9TfTBrPH9wOS7MYHJ/c3t/M3lq5v2sfxj3k6EZTCr1bud0D865mrE/tDYRPka+s+d7hVm4LusMFfe+PRqYYjyZ1R8NzKLl7f3N7f3ZblHsXlYf2Ge3nVz0QNKr3WOF/4u87XN7f3N7OZ4HXScgVGvoWVg1geZaGKdSnk7mQ7KGejSYvXS+V5inE/IdpGddnouY/mRoSmOa4REdMHXzWh+Bvn79+tf/+psn9NtmLf2J+N9g/ytaGcbsH4DrxKq3xm+d6zzMsFDXRPgYF2GJgM44XvWoxcdpqrfVWOB6oOak54xXc/Hrlvx3yNo+1Z5nH3z1ASphyJo/XSCNGOock3Po1iCQ5B4LY2reF2ZeDoE+/3p9c9eEvnz9+p9//Zvd/9leUeydzv7OnprhodtAeFA+rb60/mHc3F3f3J2Oi2IwLIq905ujgSnGZ0zn1vitc0E9F+VjF+Ni4Q+lXNcVHK9aY4aHNxfjwgwmd/YpJmV7xgM1J71hvJo8lv93yNk+KzoamOGhPkAlDFnl08nQDI6IwLXQ4cCY6iC9s7btaXW4akzN+8LMq2MEqvrNbFb+0L885HRcmCQEqjOM0heNmRNo8ZZMhkb6X3XO1Yz9obWJ9LFV5zwaGDMYu//2rjNUI+nyKhP5b386LoqiKMYXi8akBzr1pAfGenXm9jkdF2ZwdK0xBRHcVztMQqD5sKnANQftjPHMrCUo0gHqdFwYYxbG5AOmb142ge4///rp+rYJffny9f1//NXu/3T322L39HoyMMaY4Zvr20/zx8aY4s+nZQPfg/kRxbymlWFc3366vj0dF6bYPZ09WK5Kd0+lA1fP1Yz9obWJ9rFVlxgcrnqO5AxljX3U6bhY8ZnT3W8rTzkPXNYv/1+ck3q9enas798hW/tc374pz7oSMYZvLFOQsyhD1uzUNcxl2/n8z4UZHBJDLafz7fj8E/sOVkJfdWzGmMGEDlCrxmQDpm9eNoHu7j//z6ebJvTly9d/f/+fzfXfr2FAGQs+Bvto9WZgBpPNNNdsXg6B7j7/8j/XTejLly//9u//0Vz//RoGlLHgY7CPqMP/U1l8/d9/2VBzzeZlE+j27v7nXz41oV+/fPnXf3vfXP/9GgaUseBjsA/MpZyXTaALFBQUFBSUtRR3T4QGy+fPnxvtX1k6MgyUjAt8TC6wT1DJ1VyfP3+2CfSx4WKM6chfFBQUFJQWS4mfFQJFbkknlI8fP/5p/8+ty5o5BCUXfAz2gbmCJrUmAhljWieQMaZ160N5K8uQAfvAXM1NCmsgCEom+BjsA3MFTQprIFuaZkIbw5caJ5JbWvVkM02b0PFAnLIMGbAPzNXcpLwEqpsBaZVAHBX+oUw5uz2IqYlfA2mYUW3sPp49UNIiqKXy8EgCeV+FvOJ97GBn6VZbP7x9N/3w7uWTRcWTg9ZH3rZ9oBrmOtgxj1+2PcjISQkEKjOSJyAQvQb6x7//u9/+/R/2//yn/T/+7re/+d0/qmr+8PvfLMDzx9/91jwapVkDWSCZUrHbSymuTdlSftUajL4f9+zuvKYUI+UBGwApUCKBVoPF22dbj54dfng3/XD8w6M5k7IXCJTIXMc/PJr9g+ZMoFlpcg00+ra6rHk00tVUevjD73/zd7//Y1trILKBHLVlNngPEY4layxouYfrRwtpxPrYkjcLvX5cLn1ePjE7r9sffJv2geqYK681EJOo+3honk7ishdza6AqP2aPNTWVHlKugZYWYSK+cq0gtwklkFVPksOFpcwn+YxQjCQCLdxg6/nx9MO7w+dbswfW47wFAiU1V14EYtKkLrK9RohbA0US6A+//42ZX6CLXQNp0FJtzHXivuo+1TBMbjz1LWisHsjevOPhpg8JYn3s9WOzvOZmdl6DQFC8uUAgNYFM6jVQKH7kNRAZ0KdqflgNuJZBJ5KHKgxgSjFM6RxATqQ0EXbGGxAIijZXZgSi06RWkuvVVfLvgWrgJ3INJIRyEh6GWZcoCUT2pjnWbU+25IAHAkVKTyB8DwRFmwsEUhPIpPst3J9G3xrz7T8E4qfe90BupBYoVT2kuuixeKDpxO1NGJh7LMcksivrVe+QIEFcyDh8vrXgzcHO7NfY+C0cFGuuvAjEJOqeDObJaOsr7f1Ay6fGGGOS/BaODNPyY64B15VMEbLxlCJQUD9yV8J5oXoSfKy8+6e84Ib7gaA4c+VFoObSwXZ/TwQhLruA4ZYvVoh3H5AnFc4oc8gdANkz1xt5UhAoUoiwsA/MFTSpCoEaSwfb8X3hBMYILbnDyQdkb+7puJVNtTeSi1aH7vA4cApz58YMCcoyZMA+MFdzk1oSqLl0sN1fA0FQEmUZMmAfmKu5SS0J1FxC1o6vgSAoleBjsA/MFTSp6p4ITRWsgaANUZYhA/aBuZqb1JqydH9sOzm3QYpuFBQUlA4UmkBxu496diZtHby5fqCAOiX4GOwDcwVNCgSCoGSCj8E+MFfQpEAgCEom+BjsA3MFTQoEWhhCvTeo91VZytuMNA00Y9bPC7/UiFdHXL2zgn1grgACnYwW9yXG5agT7OhuTKKpKeuDdhTWEEhzV6Z7L2f1Ja5wbciuhH5M5e5UcmByZXNkhaa6XXk2Zw+eIPtAQebqrztpCXS1v70AT+VhWgK5mzNqaspjTTIC6cO6xRLlqYX+5ZNyp+OYRALPeiz0I4AT0ijA1dsearfsAwWZq8/uVOcq3NX+9vb+VXoCuRvUa2oWdt95EpZVhRuGjAeypVwjh3K3XmYJ2ZWXK263JJbkKYNAoQpw9baH2i37QEHm6rM7sQRisnR/vr273C3M8CgqSzc5FDdJl6amfANC83oJBBKif7VSOFw+NRn9rWO9hNB0wrV0Rwi6NCG9q7c+1E7ZBwoyV6/diSUQkyP1/my3MMXeWVyOVKUddQSa70meikBzQygiMrcikRtYzapIcP9ag5E7cRuThwtdCQN2Zwd5lWXIWIN9oCBz9dqdwggUj5/kBCprEhKoiVBL9ikEeg4wXOdevFWbxYwZ0ivLkLEG+0BB5uq1O/EEcnKkno4LU+ydxiVIneVIpUdT53ug4x8erQRfvfU1V+GEdYByoWCchYj3MUcgeTDKDsmWmjFDNZTlhft12AcKMlef3UlNoMnQROfn9hAo5rdwqa/CWXJjMRedvaQhw31CVMhDdVdFcrccWSGNsvzx0jrsAwWZq8/uxBLIytL9ZrASjL4dn8dk6eZGE3M/UEPfA3mpwB3oVnIvuYGeQ4I7MPmx93AvgVL52WYqyxs41mMfKMhc/XUnlkCNZulufdrC20le3SIfcIXrzX3qnnqqoB13FnIAXFccZgQyQaHqiKt3VrAPzMUTqMks3a1PO+jt9IZ1sl6AjQAqlxYu89ynwnqIAwwJTvdYmW2QrI64emcF+8BcLIEazdLd+rRzfTuhTgk+BvvAXEGTWlOW7tannevbCXVK8DHYB+YKmtSasnS3Pu1c306oU4KPwT4wV9Ck1pelGwUFBQUFhSZQ7Y1H6+9Mig8UUF6Cj8E+MFfQpEAgCEom+BjsA3MFTQoEgqBkgo/BPjBX0KRAoDAF3bnpbea9WVVuqWmjHAmURB1x9c4K9oG5AghUZumOS9KdPkt3WRO0JZ8wDPJmTPKWzEgCCSeqno47r1wpjwoQWoN4HzvYWb7JPdvIay32gWqYa56npvVxxkyKJ9DJyMwTo56M4hjE2rHezqSvH5t5TdgboPR+zUqCJAdZU+NEHJNcKLqPjW+PA7IfKJVEAvUvWKzRPlCQucoUAf1zqhpX4SKTdDeRpbt8GwI+TqYikEwXmVLk4VaNlytTB0gklurxD4qR4sPWRgsESmquXn6sYQnEZum+eFGYp5O6KbobydI909tnW2tcAwnrD+5w4bEGIe5JyZbuSECXtiQRaPF29yuf2JrsA9UxV14EYnOkGjOYdChHavnYpPseaMUiumwL3OUsDYH0le6CxlpjuYMRFmFkMyihpOX+8mJyz1KKrcM+UB1zbQCBbm7vb24vx0UUhJpaAwX+Myf8HkhoplwDkX/LV0lOWC1DQQLkrEEaH+tdWuU12wdSmyszAjlZuqvpuovxRTeydK/0EPTP3BEClSCxMOOucsjHArfIgXH1UBMCgeLtA6nNlTWBTseFGRxd39xd31yMCzOYdCVL9+HzrQWTWl4DcSsVcnVCduutdBvIqyL3EHfNhEtwzUlY7i+c9mAHv8aG0pgrLwJZWbqribpjUnQ3kaW7rEmYpXtpkbprIPKimfXU+IrmLO5jbmHktoEalcbVN3YBJNsHCjdXXgTa2CzdlmoTSO4kaA0kLFYEArkdCmSCmlBHXL2zgn1gLp5Am5qlW7MuKVuSj90O3f41LeWzuP0I6yryWJltULw64uqdFewDc7EEQpZuCIoUfAz2gbmCJoUs3RCUTPAx2AfmCpoUsnRDUDLBx2AfmCtoUsjSjYKCgoKyvkITqP7Oo7V3JsUHCigvwcdgH5graFIgEAQlE3wM9oG5giYFAkFQMsHHYB+YK2hSINDCEIpNdDTS94M7cvJTR1y9s4J9YK5gAi1zpTZAoI5k6Z4GEki4tTO0n9YdAkooX8hY2UZF4+qZKcuQ2gFz9Wl7nkACXe1vm8YIVG8f0maydHtBImw3wB2o3JsA+xRkI97HnLTKmm15257OGu0D1TNX/9J1BxHoan97ezSKy9EdmaW70p7KD5QsS7fFAA4GAoE0lMKSKG8FrIECnT8PgUDNmCuLNRCRpfvoqRken+99V+xd1k7RHZmlu9LeycWQLku3SwhrRWI1cP9aLV2WgC6bID2BAp0/E4FAzZgrCwI5OVKPBubp5Pb+bLcodi/bytJdbby4+LZ4mu57IJJAU/6SGkcgaxXlXl7DVbi8BQLF2QeqZ64cCVSCpwsEsvCzUJoMdSROZCbJBNKDBMjJTCBQnH0glbnmv1hZ/lwlDwKt5Ei9GBcrn81by9LN4mf+UsIs3d5vbgQauU+5ToR6qO/C90Bx9oHqmStDAq2k647BT2yW7tePrZ95NJelm4SH3ID7vkfAkvUqLsHlpAAC4bdwUDJzZUEgN0v3TKfjosUs3cunxphFhuMmsnRzkLBq5GWQpoHbBspGuB8ozj5QPXNlQaBNztLN8cZ9WuPKG9kVt4SCeq2OuHpnBfvAXDyBNjhLt7KSfMm6gFaixS1Th1VkG6i/6oird1awD8zFEghZuiEoUvAx2AfmCpoUsnRDUDLBx2AfmCtoUsjSDUHJBB+DfWCuoEkhSzcKCgoKyvoKTaCYvUdr7kyKDxRQXoKPwT4wV9CkQCAISib4GOwDcwVNCgSCoGSCj8E+MFfQpECgOqpx4w63E497M5Bwz5B3GPpba0Pb1J74Rqkjrt5ZwT4wl55AJ6Nl6IvKUSfYMTJLd9DmJZq3k4uwAjZKNhjqXlS3Z7KSe8w18Pagr3ErZcwAQoKCXH364R21n0qfdlhJaB8owlx98pkgAo1O6nNHQaBaWbqb25l0bhFfhJWXCC4Sqn/dw7l6t9J6rCGiy0KZju5oleeCZuJ8jHJaN79y/zIup7IPVNdc/fMZNYGu9mOzc3sJFJulO3F2hqVReBjIwXpKUcf6GxTNlbFeGLB38NXOSSzJjAGBqtL42KrTYg0ExZurTz7DEsjO0n3xoswQ1NEs3Y1lZ+CiqssDkhnC3ykT5a0GmrDuxZjVudWnzCfZDhAn5YfWitOCQFC8ufrkMyyB7Czdk6em2Du7vb+5vRwXZjDpVpZusiby7dSHYGHNoSGQTI7qIUKboEG6WCKBx5FMLg15ah/l9THHaUEgKN5cffIZNYGojN3dydIdih/57eQWAVN+rUAeUkZkmUBC5+5jcmAaKnCccMcTBBIgR5AcMiinBYGgYHNtQpbulGlSI78HSoIf4e2c6gjEhXWSFjKBvIsJL13c4QkjJx+TY3Pn662HqhJ8jHFaEAiKN1effEZLoNNxYQZH1zd31zdHA1OMz7qSpZuoiX47NQTyVrpdcVHe248SMzKiOAJxr7qsJdsLOISkD1u004JAULy5+uQzLIHcLN1vBvMo06ks3WTe7pi30/upf6r+LoTraspHcDKau33KCPE2UL5aPRfXP6gjyHPZhHBaEAiKN1effIYl0CZn6Z7botYFLrdSjuCaU5DhXk+UsobEm9CbDGOOhVCpjrh6ZwX7wFw8gTY1S/eKOcSoXW2mecla97j9C8sg8izkUonrR6AXBxhNP/KYN1wdcfXOCvaBuVgCIUs3BEUKPgb7wFxBk0KWbghKJvgY7ANzBU0KWbohKJngY7APzBU0KWTpRkFBQUFZX6EJlGIP0sCdSfGBAspL8DHYB+YKmhQIBEHJBB+DfWCuoEmBQBCUTPAx2AfmCpoUCFRHNW6Cse4N0txYw93QI3didUXe+pNqUpCljrh6ZwX7wFwhBCrzdMflShXsWCsn98HOMtJu/fA25dvJRWFNxDfUfZ1uzxwejAJR1rk0s9ATyPsq5FWQq08/vLP2U6mXfr5Hkv4HXz8m5/7yiWfnrYwNG+5OPZCeQCejBXpORiYmXSprR83OpG5N3U2QlB8ovFFYaEBSx2IGhwS3Wz1IhKfceKoDlmkH6cX5mCpLN+HquYn/HzzYMfO98FeQ8/bZVrmNno2o45evj/M2bEDkbHuotSfFEygSOxoCabIzuDVL6yd6Ox2RkZcM325jlzrWX03EV1KQ68F9lRy590QgUKg0PsZm6RZT1OchKRQQ/9THPzza2nkyN9fh82cvF8aZFctE+Rk2IHK2PdTak2KzdJ/vfWeGxzHJuZNk6SZy1r19trUIrPqNsaW3s7SFLy5zsd7thPs7ZUjgdsUxRmgsdMuNE0orBYHYLN1iivpMpFgjVvT6sXlyoDZFhobVR87Wh1p7UmyO1LPdohg+LWZhb3hUO0FqZI5UwtbLj0uWz9V8O5e2UIdpsl5mTxUeXPGeyCWQzCerkmwplxY9tY/y+piQpbvXYSXSPofPt7aePJ5/slx+3fv4pdoUWRp20wlkir2z2/ub28txYQaTzhCI6aH22znlFwpTfj1BHlJGbZlAQudCA66N3CwIJEBOpGQCyVm6ex1WIu1Tscz8Y2VpAY0pcjXshhHIytI9GZaZudvM0i1e8Vwngco21hKBjP4ygbwLDi9pyMEI/AvqFqotwcf8Wbr7fHE/1j6vH6+G1IPFrwnmRfg3z9iwm/U9kE2gm6OBGR7e3F3fXIwLM5i0lKXbqalcMj7YSfRrbOUaSK50uxJWS95+rAYcotxmU4o6QgP3LKErJ6iUFDK8Wbr7/AOnWPss7WBfWvd8yszasJv1Wzg3S/enw+E8FA0mbWXplmuS/BLBuzKYhv+GzQ3fXJTnIj7HLQEhZSckqwyPQ2HYUJA4H1Nm6e7vTR6R9pl+YO8HkgmUt2E3634gZOkWCCS3tCrlKK85hZdkcucCgbjGHPCgIHXE1Tsr2Afm4gmELN3qy1DKl6x1j9u/W9zOuTbefqpj0JxL7gfSqCOu3lnBPjAXSyBk6YagSMHHYB+YK2hSyNINQckEH4N9YK6gSSFLNwQlE3wM9oG5giaFLN0oKCgoKOsrNIFS7EEauDMpPlBAeQk+BvvAXEGTAoEgKJngY7APzBU0KRAIgpIJPgb7wFxBkwKBFoZQ344a9Kr35h75Ph75jPox486e9agjrt5ZwT4wl5ZAV/vbq7GxfqZuwY71duWZfnhXI1OqnkDu3ZpkA+uxhi5KdLnNIgnkfRVKIl/IyGGrmCbtAwWZq2a26E5NSrcGutrfrg+gqCzdqiy8cW+nAInQx95XNU/JVZFbQ57IqvESEUorPmTkkzq6GftAQeaqGQO7oDoEOhlF5etm7RiViyHlGshafJBAqkcj8kQcDzgEkjVeasqDAYGaUMCH1j5vsN+YfaAgc+W1BrKydC918aIoXpy3lKW70p7Nwhv5drpBnGumWUxwjKm+ajUWRsL1L48cdGlL+pDR6yRjjdkHCjJXXgSycqRWk6XGJEiNzJFabcxl4Y18O2WokNFcudZxn1YfcHySFzRWD3JvcmndF/MTCBRnHyjIXBtBoKOBeTqJwE8SAslZeJO8ndXo7/4lGwuVXgIJT2UWuoBRTh/IWYNAoDj7QEHmyoxAdo7UBPm5E2Tp1mThTfF2unFf4JBmiSM04FYk7rk4AgktlfCDmhC+B4qzDxRkrvwJdDEuivFZFH5is3RrsvDGvZ0ydYII5NaQ6xiyGXkuoWe3vTxUbmkFJVRAyMBv4aBYc+VFIDpLd1x+7vgs3cosvPFvp7U6mdYlENle7ke5BuLOpRwqqLMG4X6gOPtAQebKi0AbnqVbZoDxlWrjaSCB5HOR/XCn4zokhwQlV0dcvbOCfWAunkCbnaWbDNYkA+Rjq5UuSzQkIxlDDkbokzxWZhsUr464emcF+8BcLIGQpRuCIgUfg31grqBJIUs3BCUTfAz2gbmCJoUs3RCUTPAx2AfmCpoUsnSjoKCgoKyv0ASqv/No7Z1J8YECykvwMdgH5gqaFAgEQckEH4N9YK6gSYFAEJRM8DHYB+YKmhQItDCEeI+OXuQtOzXaeF+COqiOuHpnBfvAXAEEKhN1R+Wni87SPf3wjtvOJGg/R2EY3kDv3uzJISotgTRjg7qjFK6es7IMqe2ZK69deSj+zFJzn4ziGMTaUbMzqZuP9vXjxVbZYW8ANwwSKjJdDLNtgdvGSyC3mbAac4cEdUqcjxHJ5rEzKVTfXJuQpftqf3vBnZPRnEWJCRSQpZtNrKJfBnmvwnkrSbq4lcI6yaohSYYlUX+libBzB0Z2BijWXHmtgZws3Ze7xXe7F59v746H5umk5Szdq4lVlh8ejT61V73vgaw21Qccgcinbj/uS6BL36WIsPM1EDLUQdHmyotARI7U873CGGOK8XnrWbrJ74G2dp4E/OvGrIHItYuAHGFBwy2JuEoZilCn5I2wZbpFEAiKNlfeBDrfK4q9s9v7m9vLcREFoeQEKvXySXfXQNYh7omUwwZyeiTZx6rZfkEgKNpcmRFoNUdqNT93ZK7utN8DVbT4UjfN26n6RVz1gYwcbn1jHcKtloRVFNRZCT5mJ5vH90BQrLmyJtD1ZGiKvdN5rm4zmLSUpdux9fJnRWwC7zpvZ9AaaMrgx60h+RG0eMIluB5J+rBl+Sp+CwfFmisvArlZut8MFmEvLld3X+4HUl5AEw7RdDJl2IM1UAbifIxMNo/7gaA4c+VFoA3P0j03B7/6ES6dkS+RT8nDuaM4yEGdVUdcvbOCfWAunkAbnKVboI5mlUNenXOLso3VUugH6po64uqdFewDc7EEQpZuCIoUfAz2gbmCJoUs3RCUTPAx2AfmCpoUsnRDUDLBx2AfmCtoUsjSjYKCgoKyvkITqP7Oo7V3JsUHCigvwce89nl4eA8plaU7gUAQ1JTgY177tB7We6Qs3QkEgqCmBB/z2qf1sN4jZelOIFCA5PtJhaeh96jqm8kvQe2qI67eWYFAIFAAgU5G81sgY9LTyQSqtysPUxM28+oYqjsTl/vOcTeBKp9WH1g3nLo9u1CpRyDyDlbcyro2+UJGAjfutVgCXf24bb7Zv6o83f7x6uH9w8Orkfn+ZNly8XTZwD0kH6kJ1CcvUhNomZs7MkVq6izddTPU8m/nwY5ZbA359tnWolsOD8L6ZspkEpo6ayPDb3zA9aPhCjDTrngfS+bGvZZIIGNKhIBAWgL1z4u0BKok6X642t/uTpZuviZs5vZIHj07XE33IDNgStGFRIJcphTSNDXuY+9TqGlhDeS1D0ug7R/3R2Z0AgIFEah/XsQSyM7SffTUFC/O5+m6TbF32ZUs3XWNLr+d86t/lUt/xrcG0qxCZAaQdCF7AIF6IRDIax+BQFclRUCgDSSQm6V7MpzFw2IwLIrdy47lSE1MoOnbZ1tmJU2L8kqXsOghK8lX3cfcAkvoxzs2qGmBQF77SAR6eH8yWwaBQCCQhaLcCXSwY8zO8+WXQFP1VzjVxy4S3GbCgSSZaqyBvKCCGhII5LWPTKCHh1ej6mIIBKLM6Fyw6ZMX8SE5JPIAABGsSURBVASycqQu1ViO1M58D/TyyfztJH8IJ6BIxka1UkCC/LgGgbinUNMCgbz28RHo/dX+N9uj7xdP/7K/Tf1GbrMJpPCr7kpLoNNxYQZH83TdZnhYFz/Js3TXNroEwtVfKFV/jDD9YK9+5LBOLji8hwgthWWNey5uSdS6222IQCCvfbwEenh4NTLL38WdlD9PeHj/cPK9Gb2ieQMCtf3m6n2g+lSVpXtwWD9FdxNZuusZnRnGwY6V7Xvxg2wLPEuTUesb91WrUoCHkkDeNsJQAaH1CATy2kdBoPdX+98sf5n98Jf97cU/TPXn2tV/pNEroqZtfoBAnA9UnyJLNy3NlS5uCaJhhtsPuaYhj61BIGg96oird1bYE6EZAvVJPIE2OEu3IGuxQkJiSq2E4tdA3LnIDqcV8smng5pTR1y9swKBQCCWQMjSDUGRgo957dN6WO+RsnQnlkDI0g1BkYKPee3TeljvkbJ0J2FPBGTphqAowce89mk9rPdIWboTSyAUFBQUFJSmC02g+juP1t6ZtFX2QlBywce89ml9YdEjZelOIBAENSX4mNc+rYf1HilLdwKBIKgpwce89mk9rPdIWboTCEQr1W00mntC9feN4iaefqkjrt5ZgUAgUCiBVhKklnm7g5KmCnastytP2WZlN53Ama9YwRfo3Xs/OUSlJZBmbFB3FOLqBztLD1pJC5KxWAIhS3cUgbLYlccBx9ViO6YFbZZpU6sJVCMIVC9L9zyfabDduWGQUJHpYphdDNw2XgK5zbiRkEOCOiXOx8o91ytb3/YpaiS0D08gZOmuQaB8s3QTayD6YQSBamVnsHII6ZdB3qtw3kqSLm6lsE6yakiSYUnUX2k+tM4dePlha4MkEQhZuusQaKY+fZphCWRn6Z7reGieTu4+3959Pt/7rszVXX287izdyzXQ8Q+PTKVN2Mwt1VgDcQQin7r9uC+BLn2X8kPrzuvZFuzzovfhvksmELJ0bzSBmBypRwPzdHJ7f3N7f7a7zNVdfbz+HKmLS+pbO0+2EhJIqCTXLgJyhAUNtyTiKmUoQp2SN2QcPt+af35a/SAV9I1mf+UhELJ0g0C9IFCpl0+6uwayDnFPpBw2kNMjyT62xI9TvyHLIC+BkKVbQ6CNytJ9NCgTpE6G86ypN3eHg4C83Wm/B6oo7MOj9wOFN9bLBHLbkOsb6xButSSsoqDOSvAxDj9TEOgBWbrDCORoQwh0tlcUe6c3d9c3F+OiGJ+1k6V7+bOilezawTO3FLQGmjL4cWtIfgQtnnAJrkeSPmyt+mrl13EHO/g1NrJ0g0Bulu5P17efricDM3zj5O02g0mLWbobuh9IeQFNOETTyZRhD9ZAGchz2WRRZiuesnJDFkBTZOkGgZClW5aw+nEXQFMKHjUIxB3FQQ7qrDri6p0V9kRohkB9Ek+gDc7SLVBHs8pxCWSoomxjtRT6gbqmjrh6ZwUCgUAsgZClG4IiBR/z2qf1sN4jZelOLIGQpRuCIgUf89qn9bDeI2XpTsKeCMjSDUFRgo957dN6WO+RsnQnlkAoKCgoKChNF5pA2n1Gw8vHbpC8I8OAMhZ8DPaBuYImBQJBUDLBx2AfmCtoUiAQBCUTfAz2gbmCJgUCrUi426Z692jkPTrCHaw1DtSMJ/4uoqAxa07X0E1O7t1a9drUs1tHXL2zgn1grlACubnogrLTeQik2ZVHs09PwrezRjySYeBGWDma60GiH48837Rj5rqyuqU7jMvb5rVYkBk1r1rifWwTc3KH2AeqYa4+bcbDTSokSzdRE0cgzc6kmrzdcW+nJnrK0oQ57iUyUnM9KKMhF2G986o95hr9BBBIwFLlJXJU5Djdx8LsgvxBJFD/gkVygUCJzNW/5NzcpFpdA2myM4Tla6jzdsox0XpAxiNPVGUYMGVQoTmjcjxBE4wZMzkSMmRz7ecN4gjEWZI0l8YggrcE+dhm5uQOsA9Ux1y9/FjDEsibpZuvaTBLd2jOutpvpxtZZDxwld7Ibh0lxE15SN7xyDBIO2aNZCDNtYjUh8/nOay3nh/MP+49ena4usn0zuvj6kvWqIQTkaYLmgsniUCLYW/OTtgB9oHqmCsvAnlzpPI1DeZIXQ+BuNATFPGtQ5QgcVuSwKg9Hm4kacdsDZvEnksIotmcQIs39+2zLfP4pbAwEtdAwjjJYXgnQr4pKh/byJzcAfaB6pgLBMqFQBq5eCjjERmVhFDFtbd6k8GgHI9Qn3DMQudyA/vBnCjzxc387a4SqLKYMA6BSE64VvWCRGkTVxof25yMqPXsA6nNlRmBvDlS2Zoms3Q3/z3QVPcdBgmbaqXQCdmV0I/bjEOIMB5yeG7LJGMmx2Y9rvbpHmVWCPSufMfNyhqokk5UtwYibcsNz50dOfF6PlYKBIISmQsEWkOWbkXe7kRv58Ii4hU5OeJr+pkyMHB7iyQQG+X54dUec9lAxlh1bHSzkium/N3j1g+vqwRavOmz61oKAnmNKVjSHWo9H9vMnNx6+0C1zJUXgTRZupmaZrN0d+R+IC50codwlVYoJCMjF+/kxtx49MG09pi9dlM+pX6JcLy4mebxy0q9MbMfICxfIkclmG66yh7BaBq3mfp8bANzcgfZBwo3V14EQpbuuUV0kdT7UlDkqh4ixD45yHIvkR2mHbP+WHJsNc5L9hwEb2HwAplkdcTVOyvYB+biCbSpWbrdZQQZy4T1QXw05zoRTqQfj34ktcesOdBqz9m5tjjjcAbhxuAeqx9nR1y9s4J9YC6WQMjSDUGRgo/BPjBX0KSQpRuCkgk+BvvAXEGTQpZuCEom+BjsA3MFTQpZulFQUFBQ1ldoAoXsNRpWPnaD5B0ZBpSx4GNe+zw8vIeUytKdQCAIakrwMa99Wg/rPVKW7gQCQVBTgo957dN6WO+RsnQnEIhW0D00+lfdbuUSNB79mOPvtoE06oird1YgEAgUSqCVfHQno0WkDMlRJ9ixO7vyuNFfiO/kYw1dlOhym0USyPsqlES+kOE6bS83VomxDx1tr37cNt/sX1Webv949fD+4eHVyHx/smy5eLps4B6Sj9QE6pMX6Qlk5+S+2t8mHsYQSLEPaWVLxzKxSoNZuqcK0giPva9qnpKrIu86iRy8l4hQWvEhw3XaHidajrEPTyBjSoSAQFoC9c+LotZAVTpt71/FEiggF8O76Voy1FkMcF/SPxZOxPGAQyBZQw6SG7AwZSihsAby2ocl0PaP+yMzOgGBggjUPy9iCaTO0v359u5ytzDDo3Vk6a60t5JLJiOQG8S5ZprFBMeY6qtWY2EkXP/yyEGXtgQCee0jEOiqpAgItIEEUudIvT/bLUyxd7aWHKnVxmYlVXNKAglQIaO5cq3jPq0+4PgkL2isHuTe5NK6L+YnEMhrH4lAD+9PZssgEAgE4ggUip8kBHLwU8foml8icH/JxkKll0DCU5mFLmCU0wdy1iAQyGsfmUAPD69G1cUQCESZcf7jrOUvs/rkRTyBFDlST8eFKfZOQxKkxmbppvFTx+heAllxX+CQZokjNOBWJO65OAIJLZXwg5oQCOS1j49A76/2v9kefb94+pf9beo3cptNIIVfdVcRBJoMTWB+7gRZul8/Zn7mkf4q3FS9EpKfTlfjvn5tJBPIrXFXRfIpyKUVlFAgkNc+XgI9PLwameXv4k7Knyc8vH84+d6MXtG8AYHafnP1PlB9GpCl+81gJYR9Oz5fQ5bu5VNjzEqG46auwsWsgbj2cj/KNRB3LuVQQZ01CATy2kdBoPdX+98sf5n98JfFbSGrP9euxoXRK6KmbX6AQJwPVJ8iS/fCEL7fQ8ul2ngaSCD5XGQ/3Om4DskhQcnVEVfvrLAnQjME6pN4Am1qlu65IahgTTJAPrZa6bJEQzKSMeRghD7JY2W2QfHqiKt3ViAQCMQSCFm6IShS8DGvfVoP6z1Slu7EEghZuiEoUvAxr31aD+s9UpbuJOyJgCzdEBQl+JjXPq2H9R4pS3diCYSCgoKCgtJ0oQmk3ek6vHzsBsk7MgwoY8HHvPZpfWHRI2XpTiAQBDUl+JjXPq2H9R4pS3cCgSCoKcHHvPZpPaz3SFm6EwgUIPKmGeVdpcr2oc3kl6B21RFX76xAIBAolEB0lu6QJN2xWbqnH94l2c6EG8bLJ8ZOA/HkYLp6F+eKycJ3KRVuSiU7IWuULwmldefLXhpXt/IubpRYAiFLdx0C9WkznqoPVJ8GZOl+OBmZeWJUOnFqMIE0O5OmS2/Mv50HO2Z2rnfTt8+2Ft1yeBDWN1OKN9WWZJ8ckwRucVwBZtoV62OvHy/2d+9l1EhoH55AyNKtJ1D/knNXfaD6tF6W7qAk3UmydDe4BpqP5NGzw9U0rDIDphRdSCTIZUohTVPjPvY+hZqW4rJJ+dFqEyURCFm6Awg0Uy8/zbAECsjSffGiIFJ3N5qlu2ECEUmf/GsgzSpEZgBJF7IHEKgX8hOossjeQMkEQpbujSZQQI5UYwaTteZIXQOBpm+fbZmVD6fKK13CooesJF91H3MLLKEf79igpiX72OHzLYPvgQQCIUs3COQl0M3t/c3t5bgIgFAfCHSwY8zO85XPpy4DrHr3sYsEt5lwIEmmGmsgL6ighqS7Cre5EPISCFm6N5hAiizdpU7HRTG+WE+WbsbWKQn08sn8+hv5QzgBRTI2qpUCEuTHNQjEPYWalubns6sfrTZLCgIhSzcIxBDodFyYwdH1zd31zcW4MIPJWrJ0s7ZOR6CVROD2jxGmH+zVjxzWyQWH9xChpbCscc/FLYlad7sNkbDcX3y0whrIQyBk6d5QAnmzdFcTdetTdEdm6eZtnYpABzvWpfnFd8UWeJYmo9Y37qtWpQAPJYG8bYShAkLrkcbVN3YBNEWWbhAIWbqVEiJ+NawLaw6ZGW4/5JqGPLYGgaD1qCOu3llhT4SkBOqleAJtdpZuTtZihYTElFoJxa+BuHORHU4r5JNPBzWnjrh6ZwUCgUAsgZClG4IiBR/z2qf1sN4jZelOLIGQpRuCIgUf89qn9bDeI2XpTsKeCMjSDUFRgo957dN6WO+RsnQnlkAoKCgoKChNF5pA6q2ug8vHbpC8I8OAMhZ8zGuf1hcWPVKW7gQCQVBTgo957dN6WO+RsnQnEAiCmhJ8zGuf1sN6j5SlO4FAtFLdy6nvBzfo5KeOuHpnBQKBQKEEIjLULXOlRhNIsyuPUBO0v1ZCAgl3eob207pDQAnlCxkr26iot6TKRyyBkKU7ikB92p5HTyAnS3elOg2BFDuTEls61k14HEMgcvcB74FkY7m07h9QjHgfc9IqB2zLm49EAiFLdw0C9S9dd+Qa6Gp/e3s0CsnRnSZL97spsa192D+ql0BVBnAwEAikoRSWRHkrYA0U6Px5SCIQsnTXIZDjV50XSyBVlu6jp2Z4fL73XbF3qUzRnShL9ztiW/vAhMfC2+kSwlqRWA3cv1ZLlyWgyyZIT6BA589EMoGQpXujCaTIkTp/fLZbFLuX683S/e7w+dbi4tviabrvgUgCTflLahyBrFWUe3kNV+HyFgjktY9EIGTpBoEEApXgWT+BLPwsFJbsixsGiROZSTKB9CABcjITCOS1j0wgZOnWEGj+i5Xlz1XyIJAnR+rFuFj5tL62LN0MfuYv6f9RvR8ovN/cCDRyn3KdCPVQ34Xvgbz28REIWbr9BJL8qvOqTaClTseFHj+xWbpXUmi/m0YkPK5HILkB932PgCXrVVyCy0kBBMJv4Vh+IEv3RhJIk6V7ptNxsbYs3cunxphFhuN6CY8j7wcS0KJfJ5FtoGyE+4G89lEQCFm6N5JAm5ylm+ON+7TGlTeyK24JBfVaHXH1zgp7IjRDoD6JJ9CmZun2XnCTX7IuoJVoccvUYRXZBuqvOuLqnRUIBAKxBEKWbgiKFHzMa5/Ww3qPlKU7sQRClm4IihR8zGuf1sN6j5SlOwl7IiBLNwRFCT7mtU/rYb1HytKdWAKhoKCgoKA0WiwgzQnUOhghCIKgTRMIBEEQBLUjEAiCIAhqR/8LNYxxtFzA0bYAAAAASUVORK5CYII=" alt="" />

现在我们需要ResultLevel列值不为-1的所有数据行

第一种写法:"<>代表!="

select ItemId,ItemName,CheckValueNum,CheckValueString,ResultLevel from T_Check_InfoDetail where ResultLevel<>-1
select ItemId,ItemName,CheckValueNum,CheckValueString,ResultLevel from T_Check_InfoDetail where ResultLevel!=-1

aaarticlea/png;base64,iVBORw0KGgoAAAANSUhEUgAAAicAAACsCAIAAAAv2pu4AAAf8UlEQVR4nO1dPW8jR7atP7Kwf4ESDwZt/QMHG1jKjFXwyAFTB8Y4WsDYiZ4pDSAB+gGOlAxmRGkA5Zs5ICA8fSUC3u7ser160XzsiJQ0GugFJJvdVbdu3eqqZn/wFA6EZnV19a3Tl/fwUuy+6sXL1w9ltg8fPpQ6v7DVxAy0Fjf4GN/Aj1drK10fPnxQUB00tCgNPsY38OPV2krXIlTn/fv3pc4vbDUxA63FDT7GN/Dj1dpK1/v376E6aGhxGnyMb+DHq7WVropU53J7dXX7sth05rGy2eKboTIHh0yF1pZGhonL7VU1a72joq5CHHXUm0yYO1Ouw3Ige5Yyvbrx/OTNNeaK3OiQpXKtoA1Fo6j3tFRbhOq8e/dO75oYF8u9ZPPEN0Op+TsUqoNG+Vg+jB/1lOptx4qqeh/tg96qU6JXN56fh6Neau5Ew0oK3w8PD0zICj+XGfoWqDrv3r0rXXXevn2rd1WhOmWYsd2bfdaA6qARPiaIhcJGHpXrtMzrqzplenU7+ClJY8xmDVnz10e9YtlOparz9u1b9eLl60+f7sc3d2Xg/v7zv6/+T5///HmSPOkmSimlkudnk55pyvj15nluQLJ1uDnduJgdqx0ym2TxZmSNSZ6f3dwNuvPkt3vgmiF7rnL4BxYGwsdS98ji/HmSPN/sZpzkhnSGw67uSJOpDrtzh7/YTGbjOQ/MOOoN+Q7KT6J5tXks49Xt5ufmYjPJrvRiM40eWjBxrCIkZGUOtJt6tvX19DxbF2P2Cqp8BMudSwuGWT+Zd2oBU7Qu9eLl67tP96PxbRm4v//8r9//rc9/tpUkW6eTv+Pb0fiinyT9s/wulfTPbkfZjcng6cZFP1Gdwe1ofDsaPFHTeRZvxu2gqzqDTL85OT2Dca5y+AcWBsLHyCt7tpWometanSHj3uODjkr6g0n/QUfNRo5vR+Pb080k2bzIbuhn152c9UDSq81jmfdFu/kZ347GF/1poDUCQraHXoXW40nXjJxMezKYmqSZetCZ7DrbStSTAXkF6VWn5yKWP+iqlEzVPaADpmxd5arO58+ff/vX745wr1OZ+hDxfrC+EyoxY+L0tkm0fs1+7VxnfsQCdQPhY7aoSgRxi+Nlj5p9bKZmy7//TQ+UnPTM4tW2mDUm3w6t5ic78+TDrjxARQxZ05czGSNMnUrjVGgLqA7nHjMyJdfFsi714uXru7tP16ObMnD/+fM/f/tdn/90K0m2TiZ/Jy9Vd98cwGykL7O7Fm/G6OZ6dHPST5JON0m2TkYHHZX0Ty2Ta/Zr5wIaDsrHzvvJzB9SmK7LOF62R3X3R+f9RHUGN/opBul4iwdKTjqyeDV5rP3t0GZ+cjjoqO6+PEBFDFnpy0FXdQ6IwDXDfkeprJHOVet8ahPmyZRcF8u6aqA6WV+ZrMQd7ueHnPQTFUV1ipiR+p9SU9WZXYZBV3HvT+Nc5fAPLAykj+Wd86CjVKdvvtVNZ8hGz/k3SORb/aSfJEmS9M9ng0kPNPpJDwz16pbzc9JPVOfgWkIFEdDzE0ZRnanZVOCaiutE1y2r5oSQDlAn/UQpNSPTHjBd61IvXr6+vfv08XpcBu7vP7/5x2/6/Cebj5PNk+tBRymluq+uxx+n20qp5OeTdIBrY3pEMu2pxIzr8cfr8Uk/UcnmyWRjnnFunnAH5s9VDv/AwkD7WN4lOvt5z+GcIe3RjzrpJzmfOdl8nHlp88B5//z9YpzU6dWTY11vh9bycz1+lZ41FzG6rzQqyFWkIWty6gJ06Tyf/Zyozj5harqcx/2zj9YrmAl9WduUUp0BHaDyZFoDpmtd6sXL1ze3d//5OCoD9/ef//7mn+XN3ywzgBYDPgZ+pHjVUZ3BctI1WZd68fL1zc3dh/9cl4H7+/u//f0f5c3fLDOAFgM+Bn5Y7P9XJsn67/9ZUrom61IvXr4e39y+//CxDHy6v//fv70pb/5mmQG0GPAx8AO6hOtSL16+PkdDQ0NDQ1tImzyboMR2d3dX6vzCVhMz0Frc4GN8Az9era103d3dqRcvX78ruSmlavIXDQ0NDa3CNrw6nqpO4GPfmPbu3bu/bP9cOSarBYDyAB8DP6BLsqhFqI5SqnLVUUpVzjjQbrQyTIAf0BV9Uch1ACAO4GPgB3RJFoVcJwfJMGaMsrcCJ+JHav3kMMkYX3sAG1oZJsAP6Iq+KF51ilYNyquOTQn+lJZjXe2E9ITnOhKdyA42tycbQoXwGik8PFB1nHsBJ+w+trs2d6uVH349Hl4d72zMOjZ2K7e8an6AAnTtrqn1naqNLLYom+qkFbojqA6d6/z5j3/48o/fb//8l+0fv/nyi2/+LOr5/tsvZmLz4zdfqke9OLmOJh5DKl47lck2Jh3J79WMkc9jnt1c15DSRd5gBREq9I6iYASIX5+uPHq6f3U8vDr84dFUh1oPqE4kug5/eDR5g7ZNdSatzFyn9zibvjzqyXoyM3z/7Rd/+PbHqnIdcgAfqXk9cB7CHEv2aEJlHi63FpDA6mNzjZlhbz1NcXY21Npe9cZXyQ9QhK7m5zqWItaHXfVkEFbZ15brZDVjsi3pycwQM9dJYYvywpyAH+OrOlo/qRamQPKaxJ8RCAGnOjM3WHl2OLw63n+2MtnQttsNqE5UupqvOpZyorNKqAGw5TqBqvP9t1+o6ZdvobmORE6yg22TmHvNlxLd4gcPXYmLNgM5m9Me2/IBBlYf21tX8+/T1NoeVAcIpwuqw6qOip3r+EoOn+uQQXwo1gxtgG2k14l4UxkDhpRuCR0CMhMISVSdaAxUBwimqwWqQ5cTzRShK4ro/9cpIDmBuQ4TvknBUJb8Q6g65GySY83x5EibyEF1AiFXHfxfBwimC6rDqo6K9xu2v/QeK/X4T56SU+z/OmZ0ZpQpe0g2udE0QDKJORtjmHmsTYfIqbS9TpMABrYwsf9sZaYxu2uTX07jN2xAKF3NVx1LEetBZ1qotTji3q8zf6mUUirKb9jI0Mxv2wbYpuKVgxw8pFTHax5+Kua8QDEwPpbenZN+mYb7dYAwupqvOuWVSq3/swmYWGyKii1N0cK6uUGelDkjrz2mAeTMttnIk0J1AoGoCn5Al2RRM9UprVRqzZ/DxugKM9J2OLlBzmaezpbBZGcjtVCb0DTPJpbM2m02AwxaGSbAD+iKvqip6pRXKrX+uQ4AREErwwT4AV3RFzVVnfKKldY81wGAWICPgR/QJVlU+myCshpyHWBJ0MowAX5AV/RFLaKC9buqC1crlK9GQ0NDq0Gbq07YEz4dT/+sXGDb+sEBqBXgY+AHdEkWBdUBgDiAj4Ef0CVZFFQHAOIAPgZ+QJdkUVCd46H9dn3JYC8IbwOSDJDYLF8Xfm0Rjpq4em0BfkCXQ3WOerN7BcPqujHcmQ8FkfSk/V5P6pWojuROSfP+yuwuW7ONIadi5lGZO0ZJw/jO8tQUGMqeiLM8z7/x4gfwoqu57sSpzuX26kxsMptxVcd8AKKkJz1WRVMdeSjX9EN4amZ+/qS209l0iBQ5bZuZhxFLQAIPV6/a1HrxA3jR1WR3kn7Ddrm9urp9GV91zIe9S3pmXK9t+FUlsZnBSwI5ku/hw7fZz+sHOZVTS8xpSSnilwzV8YWHq1dtar34AbzoarI75VTHUsH6bnxzsZmo7kFQBWvy9GZhK0lPSrpvLSxGdZiIn+1kDudPTUZ87VinKkgmsY00LYSilAG5q1duaq34AbzoarQ75VTHUkv09nQzUcnWaVgtUSF3MtWZPt87lupMIInCtsyDH6ANy8qA+Vczhp/EHEwezkzFGGyuDnCilWFiAfwAXnQ12p3cqhMuOdFVJ+2JqDplhFdyTia420TFNrlT0rLDQmwG5GhlmFgAP4AXXY12p7zqGLVET/qJSrZOwgqJTmqJ0hYU+b/O4Q+PcgFXzrjkGzbm874wIVBGwuHctqkOb4xwQnKkxGagAFr5Rfwi+AG86GqyO7GqM+iq4NrVDtUJ+Q1b7G/YNJjx1xaRnepChviI8sCbamY//LQ2NQUkaOWPjhbBD+BFV5PdKac6WgXrV51cAHrcPwupYG2zIOR+nZL+r+NUAtuBZqdtlxncbTJgGsZvOw93qk50J1sqtPIGi8XwA3jR1Vx3yqlOqRWsK18qcwnJb67IDVuzzWa+NE89FCic7SykAbapbNLCqBHgi5q4em0BfkBXXnXKrGBd+VK9LqEzlJP9jMAw4mQqhKlz5ksm77GJCimW5rG8ngE8auLqtQX4AV051Sm1gnXlS23rJQRqBfgY+AFdkkUtooJ15Utt6yUEagX4GPgBXZJFLaKCdeVLbeslBGoF+Bj4AV2SRS2ogjUaGhoaGtpcdQo/3LP40z/xwQFoF+Bj4Ad0SRYF1QGAOICPgR/QJVkUVAcA4gA+Bn5Al2RRUB0PeN1N6RzmvIGUHykZI7QEiIKauHptAX5Al0N10grWYQWs41ewTnu8HnvHmEHeIEneJhmoOsyJsqeznZfv5K2C8CwAdh/bXZtf5IY9OGsh/AAF6JrWfKnczgKLsqjOUU9NC4ge9cJ0x8pdsad/7q2raY8f6UKPl2QMpFqQPQVOZNMhUwjNbeV61gA5DxALrOo0L0AskB/Ai6700fvNcyrhN2yBBazLqGCdUu/xsTGW6vCKwisTebjW49SSoSFCpBQV0zwgBIIPWEsNqE5Uuhr5USanOtYK1ufPE/VkULR8dSkVrCf49enKAnMdJs+wHc5sS2TDPCk50rQEilIVONWZXe5m1eBaED9AEbqarzrWWqJKdQY1qiWabqt4/9fJggzZ/PdXtsOdKuXsNBMXLZcyjWGSLXIYEBFcWj//orhhZbgWwQ9QhK6Wqs5ofDsaX/STIOEpK9fxfANH/L8OM0yY65B/072kNmgjfcUDMrMASHyscSWHF8wPIKarBapjVLDOlrJO+uf1qGCdm8HrDVwT1UnFQ5MWM5shtxmtIg2z9QNlAKoTzg8gpqt1qnPST1Tn4Hp0cz067yeqM6hLBev9ZyszHao417FlJGQWQk7r7DQH8NmPeYiZG+HrtfLApPUzp91dwy+ngTh0NV91tArW2SLWIeWry6hgnfZErGCdonCuQ34hpr1UriY5i7ltS4DMMUCpkLj60iY6PD+AP13NV52lrWCtobDq8JN45TpMUsKojjkho0ZAGaiJq9cW4Ad05VVnWStYS/KPdCS5bU5ozi8ZyZ/FnIfJn8hjeT0DwlETV68twA/oyqkOKlgDQCDgY+AHdEkWhQrWABAH8DHwA7oki0IFawCIA/gY+AFdkkWhgjUaGhoa2oLaXHWKP92z8NM/8cEBaBfgY+AHdEkWBdUBgDiAj4Ef0CVZFFQHAOIAPgZ+QJdkUVAdbxS42SV7I6fzxiDzLOQ9QL73GPGW4w6ecNTE1WsL8AO6RKozrylaguoUeiJOwWLAkktoi7ySKK+oezbNmW2SoASypJ1Lsgq56jj3Ak54ufrw6lh7qIllTHvAvQf31sm172w4niHUYmL93akBEKjO5faqKk11ilWwLvr0IeEHB2fkZQaQSqPphE0GzGnl4sG8tNmTNZhXOEAOm49Rj6w1ihATrt422N+Du2uzclk5mfn16Ur65Dpdlg539g7bTaxH5KzaVN9FMapzub262uuF1a+OXsG6aDFgebpKRlsyZJuDTaXR/kqivFD5bDOYe0nLnSeC6vhC4mP5SgeZj1BsUY92gAsFxJv68IdHK2sbU7r2nz3dmZEzaWzdkzYQ6xE5qzbVd1H2CtYHT1T38Gzr62TronD56vgVrIsWA3ZGBGcstsV3cxLb36El+ptT2XSFGcxMa7MTiAuB6mjlOebBkS1g2BIIcsEM9tbVxq6YihYSK4+clZvquyhbLdGDjnoyGN+ebibJ5kWNKlgXLQYsVx2mh+nn9SYrGHyiw5zIVB1ek7ROciTfKvfRZsHpY/vPVvIf6tsQHMP52X+2srKxPv00Of/37fqOmIpWErt0qpOKTe1UxzJD4Us4tCcEQ3veQB6SRmpedZjJmQG2MfwwL/GAzASCVx0jMh63IziG85NhZvpRMmVAQkVbiV0C1cnVEj3vJ7nPvO2uYC1RnXSMlgqQEZ9XHWdi4VQX0hhG87ymBQqD8TEqMh63498PEfjZW8+H0d3ZLwKmjXmbt5jY9v9fR6tgnS1lHSI5ZVaw9isGHJ7r8J3mVLboL5lHG2CTJXPYkFIaZoB5FlMFASG4MEH/8DITHJv8w6RQfuY86F+bOz5ZtprY9v+GzaxgPcFJP2l3BWtnBjD0/+2ZGbJtkd0W5W1axchGOgmpT4wEMmYDXrD52NyHdb9tw20l4fwMr6z36/Cq025i23+/DipYM6rDj9Q6+cguOYVTvfjJGdWxDbaJHOCFmrh6bQF+QFdedZa1gnUWTPKhDZPs0vIbc36zmZPbxjjnydogORc/DyBBTVy9tgA/oCunOqhgDQCBgI+BH9AlWRQqWANAHMDHwA/okiwKFawBIA7gY+AHdEkWhQrWaGhoaGgLanPVCXm+Z8Gnf+KDA9AuwMfAD+iSLAqqAwBxAB8DP6BLsiioDgDEAXwM/IAuyaKgOsdDn1tEvfY6b77h77Phzyi3GXfeLAY1cfXaAvyALl51jnrzYBhU143hrtgTcYZXxwUqispVx7yDkhygbUsURShX5rBA1XHuBaLAFSba8JiWMvkBvOgqWFW5DotiVKd3VFxrBKrj96xPe4XasEvICIPvtnOv5CWZ/TjzIdJ4pwoCcWEPE+0pq1wOP4AXXQVjYB3Aqs7ldmjlaqfqBNU1iJnraEkGKULFFIg8kU0DbLJH9jiVkjcGqlMGPD6cNvlh9aXxA3jR1fxcR69gff48rbBTYQXrzHhrhdrAS2gGbtswSdJg05XsXm0wY4ltft5yKEpVkIeJRhfmKo0fwIuu5quOXsF68EQlW6fj29H4op+ozqCaWqLZwbYKtYGXkBcSMoILcxrzZXbDpkl84qLNwM/Gt8r9r32A6oTxA3jR1T7VoapZV6U6fIXaKJcwG/HNv+RgptOpOsxLXv9MUREuHzKzAEB1wvgBvOhqgepYaomGlxMN/L+Ou0JtjEtoxnpGeySpDDPAlnmY57KpDjNSKHhAGcD/dcL4Abzoap3qnPQT1Tm4Ht1cjw46KumfVlTBWlKhNuwS8krjpTpmD5mvkMPIczEzm+N5U20pFBARHmECv2EDQulqvuqYFaxfdaYRqsIK1sIKteGXUMtChkVVhxzPzyPMdWznEpoKpVkAcL9OGD+AF13NV50lr2DNx33latnBQ0/V4c9FzmM7nW1C0iQgOmri6rUF+AFdedVZ7grWZIAm4z5/bLbT1A+JepG6QhrDzEkey+sZEI6auHptAX5AV051UMEaAAIBHwM/oEuyKFSwBoA4gI+BH9AlWRQqWANAHMDHwA/okiwKFazR0NDQ0BbU5qoT4zmfnk//xAcHoF2Aj4Ef0CVZFFQHAOIAPgZ+QJdkUVAdAIgD+Bj4AV2SRUF1jofsnTReZyFvqSkwxrkLqCFq4uq1BfgBXS7VSWtYh9UUZbgrVq86HeP1zETGDGdwN2/AtMlSXNWR2AbUBzFcvc1oZRitjq7mPxGH1JyJ3Bz1VEhZUSt3kqd/mrVa99Znj6D2I91mBikkvKIoy+MDzDFO1TGH2ZMuwiSgVrD5GFGIHU//BIrT1dYK1oFSI1EdjwrW1sIk8nTH+Q2bs5NUFLOTyYe0HlK9kPo0F5KoOnVgVDoAQulqfq6jVbA+2/padQ9DCldHrWCdL0wy/5Co5OWwiv1fRxuT3bCpDvnSnMfcBUVpOgRRdZrroKobEExX81VHqyV6upkk3SfJJPR2DwoXEo1UwZr8v87K2obH2zUk1yFzFEZmmMTFlvrYOnkhBGoFZ1RNSxRCdYBgutqoOirZOh3fjsYX/UR1BjVSnRQ7G/XNdbRDzBMJzYbMNAi8j2Wr4kJ1gGC6WqA6WgXrQTetWl1tBWs7v7N/zMa5hKJfsmU3eJmx5THaIbasiMmWgNqC8TG9EDv+rwOE0tU+1RkddFR3f3RzPTrvJ6ozqKiCtcHv/OdA1uLWRS6hV64ztEiO2UNqhleShK/XGgTuA5bmq/gNGxBKV/NVx6xg/XG/Ow11nUFVFaxJfku6X0f45RhziGSSoUVvkOu0ADYfIwux434dIIyu5qvOklewnoDJcpivxchd5EvycNtRNmEDaouauHptAX5AV151lriCNaM0kmyG/ObNbMIx2khmHqBuqImr1xbgB3TlVAcVrAEgEPAx8AO6JItCBWsAiAP4GPgBXZJFoYI1AMQBfAz8gC7JolDBGg0NDQ1tQW2uOjGe8+n59E98cADaBfgY+AFdkkVBdQAgDuBj4Ad0SRYF1QGAOICPgR/QJVkUVGcO5m6Y7B2dgffQMHeVFjhQYk/4XT5eNktOV9JNSObdVMXGFOOtJq5eW4Af0MWpzuX2aj4sFK9izXAneSKO5Bk5ES9hgRjEC4AZVfkILhcPuT38euPabJtKm5aecP50siJwMuZFo2SvBruP7a7NyViWp6758AMUoKv5T8ThdONye7W46IRVsJbUtA67hJKIyUMS2my7yOhsm0EYAW1R1bmuwjYXmMdDdRgpyuwirSLtNLeZ1Xn5A6s6zQsQ0QHViURXWytYZ9pRL6iWtZU7SaUDv9oHRS4hHwe1DTIGOSKpJe4PLfIgOaPQHq8FhthMWkKGadv46YAw1bExSdIlIYTxFi8fC8zhWgOoTlS6GvlRJqc6WgXrOc6fJ8nzs4oqWPvWeSt8Cc1owkuCrdMZzbWjmFjJm+S0hxeAuDZLwIvQFLPovP9sZTJ45dnu9GPdo6f7+Yc3r+0dZndpVjEnIqnzWosNnOrMzF6SAm5+/ABF6Gq+6mi1RLNFRUMKiQbWEl2M6tjCjVeU1w4Rioc5khSJwvbYLIlrs2Y2KXWmKhDDpqozu7i/Pl1R6ztMAsTmOoydpBnOhZAXReRje+tq/kXxstRw8+AHKEJXa1XnoKOeDAIkpxGqI4EpCWkMIiMRE55s47XZeDEQ2sP0R7SZmZwfoG9MVWSaxEwvd1Z1MkmDMlSH1AaTVad4CDkxIfGx5alXXYwfQExXC1RHryUaoXZ1hArW5f9fZyj7nwQpMNlOZhJyKmYec5hNNhh7SPPMkVFsJm3TtrNzmkepnOocp1dc5XKd3bX0B2CyXIfk1maeuTpy4cV8LAVUB4hEVztV57yfJP3TIMkJrWAtqGkd6RJOYYsykigvmWdoEQBztkDVsUZ2u3mFbU4H8NKVtY0elmqJSn+vuPLDXlZ1Zhd98p2VQHWcZDJMmqYW87F52fWscC4foDpR6Wq+6tAVrMNqV0epYF2T+3Vs4dJ2iK1TC39kNLTFOH6wzR55AC1ss5M34Uvq1wSHs5td1ncy/UpNfkQw30VaxVA3zOsNQ5rEbYYuH0vdeGkTHZ4fwJ+u5qsOKlhPIIyezl1e0Sp7CBPv+MBq20VOGNdm+bGkbQXOS87sJdiM8Ywa8aiJq9cW4Ad05VVnWStYm+kCGb+YPCA8gtsmYU4kt0duSWGbJQdq4208F4aNHBshNhvMY+V21sTVawvwA7pyqoMK1gAQCPgY+AFdkkWhgjUAxAF8DPyALsmiUMEaAOIAPgZ+QJdkUahgjYaGhoa2oDZXneJP9yz89E98cADaBfiYk5+HhzeAEK10J6gOAMQEfMzJT+WhvEFopTtBdQAgJuBjTn4qD+UNQivdCarjgORGHNu9IMLxvsP4XUC1qImr1xZQHaiOQ3XSItZBNd2CK1gPr46pZz9EeyLOzkbuISXpI7NsNwYKX5J3RA6NGw/JScge4S6mVe5wrYfE1Ze2zMGQUZ3Ln1bVV9uXmZerP10+vHl4+KWnvjuaj5y9nA8wD2kPXKrT/CfiUJozKVt91AvTHSt3BetVR65grT/JeDatTRKYPGZIaUx2JDmnTYcYrbJpCaSlWlh9bF5fp5GRIiI/dtVRKpUNqI5Dddpawfpye3WmNUe9qf5EVp2gugZRn/45DQq5ilt83B9SikLKAN+GlIxJesxt50ugbAi+EtEenb5c4FRn9aftnuodQXUkqjNBIz/B5FTHqGB9sZl8vXl+N7457Kong4oqWNv5jfzM6ekXIJmv9ZQr15FkG3zcJxWFnAGq0wi4VSeTTC8heNW5TJUDqrMkqkPUEj3bSpRSKumfVVZL1M5v7EoH85ouUwi/xWKSG7KT3Gtu2xIpZh6nbUDZ4H1sUqYB/9exqs7Dm6NJugPVWVLVOdtKkq3T8e1ofNFPgoSnCaqzu6bU2rPc51Az7mv95rYpA+Yw5kBSjQrkOk5xAkqC7Bu25RUep+o8PPzSyyY9UB2OzxaoTr6WaLZ2dWAd6/r/X2dnY/rdGvkDNkZ+eKnIdjIywG8XUB3bS6BsSH7quuQVrF2q8+Zy+6vV3nezl3/dXqV+2wbVuTpuoepcD7oq2TqZ1rFWnUFFFayt/MZTnb117Qdy2R8UDK/0LIcP5WRi4TyEGcmkL+a5bKlP5a62JGDS+tnHKeQ6DtV5ePilp+a/ZztKf2Lw8Obh6DvV+4XWGKhOQ5BTHbOC9avOLLCF1bGu9/06u2vaV+2z//dqYpOCzGPMvVonIxhC1XGOYUyF8CwGEldf2kRnKFWdN5fbX81/Rf3w19l9g/mfVmffSL1fiJ6qNQOqY/OB4RUqWFNgonw2lDO5Ba8T5jxk7kIeW0B1gMWgJq5eW+DZBFFVp5HIq86yVrDmoSUlpDAMqYwnPNexnYuccJhRO/50QHmoiavXFlAdqE5OdVDBGgACAR9z8lN5KG8QWulOOdVBBWsACAR8zMlP5aG8QWilO2nPJkAFawAIAnzMyU/lobxBaKU75VQHDQ0NDQ2t1DbRHvXi5evKBRAAAABYEvw/K+s7DBj6rtsAAAAASUVORK5CYII=" alt="" />

第二种写法:

select ItemId,ItemName,CheckValueNum,CheckValueString,ResultLevel from T_Check_InfoDetail where NOT ResultLevel=-1  

aaarticlea/png;base64,iVBORw0KGgoAAAANSUhEUgAAAicAAACsCAIAAAAv2pu4AAAf8UlEQVR4nO1dPW8jR7atP7Kwf4ESDwZt/QMHG1jKjFXwyAFTB8Y4WsDYiZ4pDSAB+gGOlAxmRGkA5Zs5ICA8fSUC3u7ser160XzsiJQ0GugFJJvdVbdu3eqqZn/wFA6EZnV19a3Tl/fwUuy+6sXL1w9ltg8fPpQ6v7DVxAy0Fjf4GN/Aj1drK10fPnxQUB00tCgNPsY38OPV2krXIlTn/fv3pc4vbDUxA63FDT7GN/Dj1dpK1/v376E6aGhxGnyMb+DHq7WVropU53J7dXX7sth05rGy2eKboTIHh0yF1pZGhonL7VU1a72joq5CHHXUm0yYO1Ouw3Ige5Yyvbrx/OTNNeaK3OiQpXKtoA1Fo6j3tFRbhOq8e/dO75oYF8u9ZPPEN0Op+TsUqoNG+Vg+jB/1lOptx4qqeh/tg96qU6JXN56fh6Neau5Ew0oK3w8PD0zICj+XGfoWqDrv3r0rXXXevn2rd1WhOmWYsd2bfdaA6qARPiaIhcJGHpXrtMzrqzplenU7+ClJY8xmDVnz10e9YtlOparz9u1b9eLl60+f7sc3d2Xg/v7zv6/+T5///HmSPOkmSimlkudnk55pyvj15nluQLJ1uDnduJgdqx0ym2TxZmSNSZ6f3dwNuvPkt3vgmiF7rnL4BxYGwsdS98ji/HmSPN/sZpzkhnSGw67uSJOpDrtzh7/YTGbjOQ/MOOoN+Q7KT6J5tXks49Xt5ufmYjPJrvRiM40eWjBxrCIkZGUOtJt6tvX19DxbF2P2Cqp8BMudSwuGWT+Zd2oBU7Qu9eLl67tP96PxbRm4v//8r9//rc9/tpUkW6eTv+Pb0fiinyT9s/wulfTPbkfZjcng6cZFP1Gdwe1ofDsaPFHTeRZvxu2gqzqDTL85OT2Dca5y+AcWBsLHyCt7tpWometanSHj3uODjkr6g0n/QUfNRo5vR+Pb080k2bzIbuhn152c9UDSq81jmfdFu/kZ347GF/1poDUCQraHXoXW40nXjJxMezKYmqSZetCZ7DrbStSTAXkF6VWn5yKWP+iqlEzVPaADpmxd5arO58+ff/vX745wr1OZ+hDxfrC+EyoxY+L0tkm0fs1+7VxnfsQCdQPhY7aoSgRxi+Nlj5p9bKZmy7//TQ+UnPTM4tW2mDUm3w6t5ic78+TDrjxARQxZ05czGSNMnUrjVGgLqA7nHjMyJdfFsi714uXru7tP16ObMnD/+fM/f/tdn/90K0m2TiZ/Jy9Vd98cwGykL7O7Fm/G6OZ6dHPST5JON0m2TkYHHZX0Ty2Ta/Zr5wIaDsrHzvvJzB9SmK7LOF62R3X3R+f9RHUGN/opBul4iwdKTjqyeDV5rP3t0GZ+cjjoqO6+PEBFDFnpy0FXdQ6IwDXDfkeprJHOVet8ahPmyZRcF8u6aqA6WV+ZrMQd7ueHnPQTFUV1ipiR+p9SU9WZXYZBV3HvT+Nc5fAPLAykj+Wd86CjVKdvvtVNZ8hGz/k3SORb/aSfJEmS9M9ng0kPNPpJDwz16pbzc9JPVOfgWkIFEdDzE0ZRnanZVOCaiutE1y2r5oSQDlAn/UQpNSPTHjBd61IvXr6+vfv08XpcBu7vP7/5x2/6/Cebj5PNk+tBRymluq+uxx+n20qp5OeTdIBrY3pEMu2pxIzr8cfr8Uk/UcnmyWRjnnFunnAH5s9VDv/AwkD7WN4lOvt5z+GcIe3RjzrpJzmfOdl8nHlp88B5//z9YpzU6dWTY11vh9bycz1+lZ41FzG6rzQqyFWkIWty6gJ06Tyf/Zyozj5harqcx/2zj9YrmAl9WduUUp0BHaDyZFoDpmtd6sXL1ze3d//5OCoD9/ef//7mn+XN3ywzgBYDPgZ+pHjVUZ3BctI1WZd68fL1zc3dh/9cl4H7+/u//f0f5c3fLDOAFgM+Bn5Y7P9XJsn67/9ZUrom61IvXr4e39y+//CxDHy6v//fv70pb/5mmQG0GPAx8AO6hOtSL16+PkdDQ0NDQ1tImzyboMR2d3dX6vzCVhMz0Frc4GN8Az9era103d3dqRcvX78ruSmlavIXDQ0NDa3CNrw6nqpO4GPfmPbu3bu/bP9cOSarBYDyAB8DP6BLsqhFqI5SqnLVUUpVzjjQbrQyTIAf0BV9Uch1ACAO4GPgB3RJFoVcJwfJMGaMsrcCJ+JHav3kMMkYX3sAG1oZJsAP6Iq+KF51ilYNyquOTQn+lJZjXe2E9ITnOhKdyA42tycbQoXwGik8PFB1nHsBJ+w+trs2d6uVH349Hl4d72zMOjZ2K7e8an6AAnTtrqn1naqNLLYom+qkFbojqA6d6/z5j3/48o/fb//8l+0fv/nyi2/+LOr5/tsvZmLz4zdfqke9OLmOJh5DKl47lck2Jh3J79WMkc9jnt1c15DSRd5gBREq9I6iYASIX5+uPHq6f3U8vDr84dFUh1oPqE4kug5/eDR5g7ZNdSatzFyn9zibvjzqyXoyM3z/7Rd/+PbHqnIdcgAfqXk9cB7CHEv2aEJlHi63FpDA6mNzjZlhbz1NcXY21Npe9cZXyQ9QhK7m5zqWItaHXfVkEFbZ15brZDVjsi3pycwQM9dJYYvywpyAH+OrOlo/qRamQPKaxJ8RCAGnOjM3WHl2OLw63n+2MtnQttsNqE5UupqvOpZyorNKqAGw5TqBqvP9t1+o6ZdvobmORE6yg22TmHvNlxLd4gcPXYmLNgM5m9Me2/IBBlYf21tX8+/T1NoeVAcIpwuqw6qOip3r+EoOn+uQQXwo1gxtgG2k14l4UxkDhpRuCR0CMhMISVSdaAxUBwimqwWqQ5cTzRShK4ro/9cpIDmBuQ4TvknBUJb8Q6g65GySY83x5EibyEF1AiFXHfxfBwimC6rDqo6K9xu2v/QeK/X4T56SU+z/OmZ0ZpQpe0g2udE0QDKJORtjmHmsTYfIqbS9TpMABrYwsf9sZaYxu2uTX07jN2xAKF3NVx1LEetBZ1qotTji3q8zf6mUUirKb9jI0Mxv2wbYpuKVgxw8pFTHax5+Kua8QDEwPpbenZN+mYb7dYAwupqvOuWVSq3/swmYWGyKii1N0cK6uUGelDkjrz2mAeTMttnIk0J1AoGoCn5Al2RRM9UprVRqzZ/DxugKM9J2OLlBzmaezpbBZGcjtVCb0DTPJpbM2m02AwxaGSbAD+iKvqip6pRXKrX+uQ4AREErwwT4AV3RFzVVnfKKldY81wGAWICPgR/QJVlU+myCshpyHWBJ0MowAX5AV/RFLaKC9buqC1crlK9GQ0NDq0Gbq07YEz4dT/+sXGDb+sEBqBXgY+AHdEkWBdUBgDiAj4Ef0CVZFFQHAOIAPgZ+QJdkUVCd46H9dn3JYC8IbwOSDJDYLF8Xfm0Rjpq4em0BfkCXQ3WOerN7BcPqujHcmQ8FkfSk/V5P6pWojuROSfP+yuwuW7ONIadi5lGZO0ZJw/jO8tQUGMqeiLM8z7/x4gfwoqu57sSpzuX26kxsMptxVcd8AKKkJz1WRVMdeSjX9EN4amZ+/qS209l0iBQ5bZuZhxFLQAIPV6/a1HrxA3jR1WR3kn7Ddrm9urp9GV91zIe9S3pmXK9t+FUlsZnBSwI5ku/hw7fZz+sHOZVTS8xpSSnilwzV8YWHq1dtar34AbzoarI75VTHUsH6bnxzsZmo7kFQBWvy9GZhK0lPSrpvLSxGdZiIn+1kDudPTUZ87VinKkgmsY00LYSilAG5q1duaq34AbzoarQ75VTHUkv09nQzUcnWaVgtUSF3MtWZPt87lupMIInCtsyDH6ANy8qA+Vczhp/EHEwezkzFGGyuDnCilWFiAfwAXnQ12p3cqhMuOdFVJ+2JqDplhFdyTia420TFNrlT0rLDQmwG5GhlmFgAP4AXXY12p7zqGLVET/qJSrZOwgqJTmqJ0hYU+b/O4Q+PcgFXzrjkGzbm874wIVBGwuHctqkOb4xwQnKkxGagAFr5Rfwi+AG86GqyO7GqM+iq4NrVDtUJ+Q1b7G/YNJjx1xaRnepChviI8sCbamY//LQ2NQUkaOWPjhbBD+BFV5PdKac6WgXrV51cAHrcPwupYG2zIOR+nZL+r+NUAtuBZqdtlxncbTJgGsZvOw93qk50J1sqtPIGi8XwA3jR1Vx3yqlOqRWsK18qcwnJb67IDVuzzWa+NE89FCic7SykAbapbNLCqBHgi5q4em0BfkBXXnXKrGBd+VK9LqEzlJP9jMAw4mQqhKlz5ksm77GJCimW5rG8ngE8auLqtQX4AV051Sm1gnXlS23rJQRqBfgY+AFdkkUtooJ15Utt6yUEagX4GPgBXZJFLaKCdeVLbeslBGoF+Bj4AV2SRS2ogjUaGhoaGtpcdQo/3LP40z/xwQFoF+Bj4Ad0SRYF1QGAOICPgR/QJVkUVAcA4gA+Bn5Al2RRUB0PeN1N6RzmvIGUHykZI7QEiIKauHptAX5Al0N10grWYQWs41ewTnu8HnvHmEHeIEneJhmoOsyJsqeznZfv5K2C8CwAdh/bXZtf5IY9OGsh/AAF6JrWfKnczgKLsqjOUU9NC4ge9cJ0x8pdsad/7q2raY8f6UKPl2QMpFqQPQVOZNMhUwjNbeV61gA5DxALrOo0L0AskB/Ai6700fvNcyrhN2yBBazLqGCdUu/xsTGW6vCKwisTebjW49SSoSFCpBQV0zwgBIIPWEsNqE5Uuhr5USanOtYK1ufPE/VkULR8dSkVrCf49enKAnMdJs+wHc5sS2TDPCk50rQEilIVONWZXe5m1eBaED9AEbqarzrWWqJKdQY1qiWabqt4/9fJggzZ/PdXtsOdKuXsNBMXLZcyjWGSLXIYEBFcWj//orhhZbgWwQ9QhK6Wqs5ofDsaX/STIOEpK9fxfANH/L8OM0yY65B/072kNmgjfcUDMrMASHyscSWHF8wPIKarBapjVLDOlrJO+uf1qGCdm8HrDVwT1UnFQ5MWM5shtxmtIg2z9QNlAKoTzg8gpqt1qnPST1Tn4Hp0cz067yeqM6hLBev9ZyszHao417FlJGQWQk7r7DQH8NmPeYiZG+HrtfLApPUzp91dwy+ngTh0NV91tArW2SLWIeWry6hgnfZErGCdonCuQ34hpr1UriY5i7ltS4DMMUCpkLj60iY6PD+AP13NV52lrWCtobDq8JN45TpMUsKojjkho0ZAGaiJq9cW4Ad05VVnWStYS/KPdCS5bU5ozi8ZyZ/FnIfJn8hjeT0DwlETV68twA/oyqkOKlgDQCDgY+AHdEkWhQrWABAH8DHwA7oki0IFawCIA/gY+AFdkkWhgjUaGhoa2oLaXHWKP92z8NM/8cEBaBfgY+AHdEkWBdUBgDiAj4Ef0CVZFFQHAOIAPgZ+QJdkUVAdbxS42SV7I6fzxiDzLOQ9QL73GPGW4w6ecNTE1WsL8AO6RKozrylaguoUeiJOwWLAkktoi7ySKK+oezbNmW2SoASypJ1Lsgq56jj3Ak54ufrw6lh7qIllTHvAvQf31sm172w4niHUYmL93akBEKjO5faqKk11ilWwLvr0IeEHB2fkZQaQSqPphE0GzGnl4sG8tNmTNZhXOEAOm49Rj6w1ihATrt422N+Du2uzclk5mfn16Ur65Dpdlg539g7bTaxH5KzaVN9FMapzub262uuF1a+OXsG6aDFgebpKRlsyZJuDTaXR/kqivFD5bDOYe0nLnSeC6vhC4mP5SgeZj1BsUY92gAsFxJv68IdHK2sbU7r2nz3dmZEzaWzdkzYQ6xE5qzbVd1H2CtYHT1T38Gzr62TronD56vgVrIsWA3ZGBGcstsV3cxLb36El+ptT2XSFGcxMa7MTiAuB6mjlOebBkS1g2BIIcsEM9tbVxq6YihYSK4+clZvquyhbLdGDjnoyGN+ebibJ5kWNKlgXLQYsVx2mh+nn9SYrGHyiw5zIVB1ek7ROciTfKvfRZsHpY/vPVvIf6tsQHMP52X+2srKxPv00Of/37fqOmIpWErt0qpOKTe1UxzJD4Us4tCcEQ3veQB6SRmpedZjJmQG2MfwwL/GAzASCVx0jMh63IziG85NhZvpRMmVAQkVbiV0C1cnVEj3vJ7nPvO2uYC1RnXSMlgqQEZ9XHWdi4VQX0hhG87ymBQqD8TEqMh63498PEfjZW8+H0d3ZLwKmjXmbt5jY9v9fR6tgnS1lHSI5ZVaw9isGHJ7r8J3mVLboL5lHG2CTJXPYkFIaZoB5FlMFASG4MEH/8DITHJv8w6RQfuY86F+bOz5ZtprY9v+GzaxgPcFJP2l3BWtnBjD0/+2ZGbJtkd0W5W1axchGOgmpT4wEMmYDXrD52NyHdb9tw20l4fwMr6z36/Cq025i23+/DipYM6rDj9Q6+cguOYVTvfjJGdWxDbaJHOCFmrh6bQF+QFdedZa1gnUWTPKhDZPs0vIbc36zmZPbxjjnydogORc/DyBBTVy9tgA/oCunOqhgDQCBgI+BH9AlWRQqWANAHMDHwA/okiwKFawBIA7gY+AHdEkWhQrWaGhoaGgLanPVCXm+Z8Gnf+KDA9AuwMfAD+iSLAqqAwBxAB8DP6BLsiioDgDEAXwM/IAuyaKgOsdDn1tEvfY6b77h77Phzyi3GXfeLAY1cfXaAvyALl51jnrzYBhU143hrtgTcYZXxwUqispVx7yDkhygbUsURShX5rBA1XHuBaLAFSba8JiWMvkBvOgqWFW5DotiVKd3VFxrBKrj96xPe4XasEvICIPvtnOv5CWZ/TjzIdJ4pwoCcWEPE+0pq1wOP4AXXQVjYB3Aqs7ldmjlaqfqBNU1iJnraEkGKULFFIg8kU0DbLJH9jiVkjcGqlMGPD6cNvlh9aXxA3jR1fxcR69gff48rbBTYQXrzHhrhdrAS2gGbtswSdJg05XsXm0wY4ltft5yKEpVkIeJRhfmKo0fwIuu5quOXsF68EQlW6fj29H4op+ozqCaWqLZwbYKtYGXkBcSMoILcxrzZXbDpkl84qLNwM/Gt8r9r32A6oTxA3jR1T7VoapZV6U6fIXaKJcwG/HNv+RgptOpOsxLXv9MUREuHzKzAEB1wvgBvOhqgepYaomGlxMN/L+Ou0JtjEtoxnpGeySpDDPAlnmY57KpDjNSKHhAGcD/dcL4Abzoap3qnPQT1Tm4Ht1cjw46KumfVlTBWlKhNuwS8krjpTpmD5mvkMPIczEzm+N5U20pFBARHmECv2EDQulqvuqYFaxfdaYRqsIK1sIKteGXUMtChkVVhxzPzyPMdWznEpoKpVkAcL9OGD+AF13NV50lr2DNx33latnBQ0/V4c9FzmM7nW1C0iQgOmri6rUF+AFdedVZ7grWZIAm4z5/bLbT1A+JepG6QhrDzEkey+sZEI6auHptAX5AV051UMEaAAIBHwM/oEuyKFSwBoA4gI+BH9AlWRQqWANAHMDHwA/okiwKFazR0NDQ0BbU5qoT4zmfnk//xAcHoF2Aj4Ef0CVZFFQHAOIAPgZ+QJdkUVAdAIgD+Bj4AV2SRUF1jofsnTReZyFvqSkwxrkLqCFq4uq1BfgBXS7VSWtYh9UUZbgrVq86HeP1zETGDGdwN2/AtMlSXNWR2AbUBzFcvc1oZRitjq7mPxGH1JyJ3Bz1VEhZUSt3kqd/mrVa99Znj6D2I91mBikkvKIoy+MDzDFO1TGH2ZMuwiSgVrD5GFGIHU//BIrT1dYK1oFSI1EdjwrW1sIk8nTH+Q2bs5NUFLOTyYe0HlK9kPo0F5KoOnVgVDoAQulqfq6jVbA+2/padQ9DCldHrWCdL0wy/5Co5OWwiv1fRxuT3bCpDvnSnMfcBUVpOgRRdZrroKobEExX81VHqyV6upkk3SfJJPR2DwoXEo1UwZr8v87K2obH2zUk1yFzFEZmmMTFlvrYOnkhBGoFZ1RNSxRCdYBgutqoOirZOh3fjsYX/UR1BjVSnRQ7G/XNdbRDzBMJzYbMNAi8j2Wr4kJ1gGC6WqA6WgXrQTetWl1tBWs7v7N/zMa5hKJfsmU3eJmx5THaIbasiMmWgNqC8TG9EDv+rwOE0tU+1RkddFR3f3RzPTrvJ6ozqKiCtcHv/OdA1uLWRS6hV64ztEiO2UNqhleShK/XGgTuA5bmq/gNGxBKV/NVx6xg/XG/Ow11nUFVFaxJfku6X0f45RhziGSSoUVvkOu0ADYfIwux434dIIyu5qvOklewnoDJcpivxchd5EvycNtRNmEDaouauHptAX5AV151lriCNaM0kmyG/ObNbMIx2khmHqBuqImr1xbgB3TlVAcVrAEgEPAx8AO6JItCBWsAiAP4GPgBXZJFoYI1AMQBfAz8gC7JolDBGg0NDQ1tQW2uOjGe8+n59E98cADaBfgY+AFdkkVBdQAgDuBj4Ad0SRYF1QGAOICPgR/QJVkUVGcO5m6Y7B2dgffQMHeVFjhQYk/4XT5eNktOV9JNSObdVMXGFOOtJq5eW4Af0MWpzuX2aj4sFK9izXAneSKO5Bk5ES9hgRjEC4AZVfkILhcPuT38euPabJtKm5aecP50siJwMuZFo2SvBruP7a7NyViWp6758AMUoKv5T8ThdONye7W46IRVsJbUtA67hJKIyUMS2my7yOhsm0EYAW1R1bmuwjYXmMdDdRgpyuwirSLtNLeZ1Xn5A6s6zQsQ0QHViURXWytYZ9pRL6iWtZU7SaUDv9oHRS4hHwe1DTIGOSKpJe4PLfIgOaPQHq8FhthMWkKGadv46YAw1bExSdIlIYTxFi8fC8zhWgOoTlS6GvlRJqc6WgXrOc6fJ8nzs4oqWPvWeSt8Cc1owkuCrdMZzbWjmFjJm+S0hxeAuDZLwIvQFLPovP9sZTJ45dnu9GPdo6f7+Yc3r+0dZndpVjEnIqnzWosNnOrMzF6SAm5+/ABF6Gq+6mi1RLNFRUMKiQbWEl2M6tjCjVeU1w4Rioc5khSJwvbYLIlrs2Y2KXWmKhDDpqozu7i/Pl1R6ztMAsTmOoydpBnOhZAXReRje+tq/kXxstRw8+AHKEJXa1XnoKOeDAIkpxGqI4EpCWkMIiMRE55s47XZeDEQ2sP0R7SZmZwfoG9MVWSaxEwvd1Z1MkmDMlSH1AaTVad4CDkxIfGx5alXXYwfQExXC1RHryUaoXZ1hArW5f9fZyj7nwQpMNlOZhJyKmYec5hNNhh7SPPMkVFsJm3TtrNzmkepnOocp1dc5XKd3bX0B2CyXIfk1maeuTpy4cV8LAVUB4hEVztV57yfJP3TIMkJrWAtqGkd6RJOYYsykigvmWdoEQBztkDVsUZ2u3mFbU4H8NKVtY0elmqJSn+vuPLDXlZ1Zhd98p2VQHWcZDJMmqYW87F52fWscC4foDpR6Wq+6tAVrMNqV0epYF2T+3Vs4dJ2iK1TC39kNLTFOH6wzR55AC1ss5M34Uvq1wSHs5td1ncy/UpNfkQw30VaxVA3zOsNQ5rEbYYuH0vdeGkTHZ4fwJ+u5qsOKlhPIIyezl1e0Sp7CBPv+MBq20VOGNdm+bGkbQXOS87sJdiM8Ywa8aiJq9cW4Ad05VVnWStYm+kCGb+YPCA8gtsmYU4kt0duSWGbJQdq4208F4aNHBshNhvMY+V21sTVawvwA7pyqoMK1gAQCPgY+AFdkkWhgjUAxAF8DPyALsmiUMEaAOIAPgZ+QJdkUahgjYaGhoa2oDZXneJP9yz89E98cADaBfiYk5+HhzeAEK10J6gOAMQEfMzJT+WhvEFopTtBdQAgJuBjTn4qD+UNQivdCarjgORGHNu9IMLxvsP4XUC1qImr1xZQHaiOQ3XSItZBNd2CK1gPr46pZz9EeyLOzkbuISXpI7NsNwYKX5J3RA6NGw/JScge4S6mVe5wrYfE1Ze2zMGQUZ3Ln1bVV9uXmZerP10+vHl4+KWnvjuaj5y9nA8wD2kPXKrT/CfiUJozKVt91AvTHSt3BetVR65grT/JeDatTRKYPGZIaUx2JDmnTYcYrbJpCaSlWlh9bF5fp5GRIiI/dtVRKpUNqI5Dddpawfpye3WmNUe9qf5EVp2gugZRn/45DQq5ilt83B9SikLKAN+GlIxJesxt50ugbAi+EtEenb5c4FRn9aftnuodQXUkqjNBIz/B5FTHqGB9sZl8vXl+N7457Kong4oqWNv5jfzM6ekXIJmv9ZQr15FkG3zcJxWFnAGq0wi4VSeTTC8heNW5TJUDqrMkqkPUEj3bSpRSKumfVVZL1M5v7EoH85ouUwi/xWKSG7KT3Gtu2xIpZh6nbUDZ4H1sUqYB/9exqs7Dm6NJugPVWVLVOdtKkq3T8e1ofNFPgoSnCaqzu6bU2rPc51Az7mv95rYpA+Yw5kBSjQrkOk5xAkqC7Bu25RUep+o8PPzSyyY9UB2OzxaoTr6WaLZ2dWAd6/r/X2dnY/rdGvkDNkZ+eKnIdjIywG8XUB3bS6BsSH7quuQVrF2q8+Zy+6vV3nezl3/dXqV+2wbVuTpuoepcD7oq2TqZ1rFWnUFFFayt/MZTnb117Qdy2R8UDK/0LIcP5WRi4TyEGcmkL+a5bKlP5a62JGDS+tnHKeQ6DtV5ePilp+a/ZztKf2Lw8Obh6DvV+4XWGKhOQ5BTHbOC9avOLLCF1bGu9/06u2vaV+2z//dqYpOCzGPMvVonIxhC1XGOYUyF8CwGEldf2kRnKFWdN5fbX81/Rf3w19l9g/mfVmffSL1fiJ6qNQOqY/OB4RUqWFNgonw2lDO5Ba8T5jxk7kIeW0B1gMWgJq5eW+DZBFFVp5HIq86yVrDmoSUlpDAMqYwnPNexnYuccJhRO/50QHmoiavXFlAdqE5OdVDBGgACAR9z8lN5KG8QWulOOdVBBWsACAR8zMlP5aG8QWilO2nPJkAFawAIAnzMyU/lobxBaKU75VQHDQ0NDQ2t1DbRHvXi5evKBRAAAABYEvw/K+s7DBj6rtsAAAAASUVORK5CYII=" alt="" />

两种方法的检索结果都一样,但是为什么我们要用NOT?原因如下:

对于上面这种简单的where语句,使用NOT确实没什么优势。但在更复杂的子句中,NOT是非常有用的。例如,在与IN操作符联合使用时,NOT可以非常简单的找出与条件列表不匹配的行。

select ItemId,ItemName,CheckValueNum,CheckValueString,ResultLevel from T_Check_InfoDetail where ResultLevel!=-1