---
title: "Use of IN Operator in Sql Server"  
description: "In this article I will explain about IN operator in Sql Server with example"  
author: "Sushant Mishra"  
published: 2017-09-28  
updated: 2018-03-27  
canonical: https://www.mindstick.com/articles/12620/use-of-in-operator-in-sql-server  
category: "database"  
tags: ["sql server", "sql server 2008", "sql server 2012"]  
reading_time: 2 minutes  

---

# Use of IN Operator in Sql Server

In this article I will explain about IN operator in Sql Server with example

It helps to specify multiple values in where clause it determines whether a specified value matches any value in a subquery or a list The SQL IN condition allows you to easily test if an expression matches any value in a list of values. It helps to reduce the need for multiple OR conditions in a DML statement.

Syntax for IN Condition

```
SELECT column_name(s)FROM table_nameWHERE column_name IN (value1, value2, ...); SELECT column_name(s)FROM table_nameWHERE column_name IN (SELECT STATEMENT);
```

Let us take an example to see the implementation

First create table E_Salary

```
CREATE TABLE E_Salary(     [Id] [int] IDENTITY(1,1) NOT NULL,     [S_Id] [varchar](50) NULL,     [Name] [varchar](50) NULL,     [City] [varchar](50) NULL,     [Salary] [varchar](50) NULL,     )
```

I have inserted some records in it shown in below screen shot

![Use of IN Operator in Sql Server](file:///C:\Users\MSCLIE~1\AppData\Local\Temp\msohtmlclip1\01\clip_image001.png)![Use of IN Operator in Sql Server](data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAAS8AAADQCAIAAAGuCEBhAAAAAXNSR0IArs4c6QAAAARnQU1BAACxjwv8YQUAAAAJcEhZcwAADsMAAA7DAcdvqGQAACdMSURBVHhe7Z07b+TItcf7OwkK1B/FgGE54ddY4AbCzaajBZQpWGwiO1kDHY9TW9ANFwNigsViAWNgAzOONtP9n0cVi/VisZtssqn6gaKKxXqcU6cOWUWyyd1bjK9zsvuURpNMjWr57ds3rJtdI5sCdj89/YD17W7HiaeBqrxjpBoX7NYqbx++vj7vdrvXh3usH14566nsnv/6N63h7e23337zAnPgV9m+tRI4NHuJFPb7w36HPyeyxdbBs4WAlqD0qb3LaAn5ZQMN/a///N+//vNfBKAF9D3Kjji/vLXfvb09UaC3SDdsD9ReEXpacpX/NVVKpRm8muxCZLL6VXqBOaAq0Q9kI1Pl4YiOdWjbg24ztEnth329htxzsElYhapEBbOiVRkGGnZve3l7gNvs9g0CGsOdq2n2+30Dr3DjBdE1ZCFbajCoEg5t7YGwhhysdwlWKSgt6Y/944kwVKVpHIQRRCNyadqG6HdYEIFEWLBT4t/aIyLxf3SVMzFQpW269tjAJaAKxZieghirogRcVtZ9rG2opiN5haNlxBgdVl1nDYYPBRq8pJYavBS1yplYokr93wc9dj6WG60D68ht+wFrVPnTTz9pqq/nDZb7UJXRoTqq/PLly88//yzpMELHNGFnhu0SeRpxW7pMPqb1q8QZQ0N0/qNDKA/hCT5f6kFVCQYfPRJ7l9YSg+YfeeiMMJ8GSD20PgWN0oZfMBpodn/Y7zFgjwydObHtkT38KmXRbcZW2cerxl2U1IB9uGETVZ5Oskp7fkWVaCUZhbhg/O6M0zlgQPJd6gSNKlHi3GhVBtLSlccOz10tadLCPR7jdYkEUA3DSxwWoI+d1QjQODXWAiuwpZXO1dJ1ausqNhCqQ5pjrsKj55B8lRTWKnkAjm23SsRQz6Iwt7wj2YgqQ2ZpWNfUtiP0GpY6jvYgqwpikA2LaN8VwQW6ZXospGWUVPdxhfeUs8BtcocC/Z/mclrOR61yJpaoEh1y82i7No8vWG6aF9nMI1MHDOWd0fyqUSU/fvwIiZ+efpBNHMTs8eqICUr7QaYpEiVKIvD48vL582cp6Pb24f724eEWYArx8GwisbaRHLcAp3jIfJPAmUhO2mUaQuclc9aSGDu0sKMRILtwRnYjM+CMrqFiTshiGVZyb65tSoytTEZaEraJd87wC4Oz1EBE0iTP3zGQpT00dHWW1xpbRlJJWNlOwWRBjO4LyOwK8CZoJcu5DCsps1tXSWsBG9Bd7YHaGANSvrnGe0JIbsyA2/Y7TIXf3p5is2FvUaR/5IeqUd6ZJb3msXLbmYKNsQYMdxF2eO2MsyOY2bit1a0+tJT1Q5rMjfLmvCU1ZMiYK7NrDZyqZP9KzsWUtNVmbv2GqJJhHxC50SHdG+ISQEJUEe7iA/yRbk9RArqT2xxa72auwP38iP0iqj1QUQnHVCeXtC1SckeXzSLeU3dt9t21XsHIfbQHJKuJNbm/i40Go4hZ9rtGBsDh6cQdNtFe2JSuAVIJVCRvSmkeXLaeQmxgkHdlyeCpGCN356kmphWffDs2NleX2Gn+rpGj55LxpxAW5ZI+eY1H15ABJftcTMnTUCVDJ1a5cT4oH/Fwt8RpgHrUfifX5A+NXjB1oVsNfJNBOm0sEEFOcieOeCDitaPaJEh21y1RldwKVcmtoGPIEvRAdoW8j9sEn8ajWa8H6q72RkjhvRBkk9sKUkQ5SzVQzyf1mSm+7dGj/eCOs5Dt8fFFfvPgQg9SZVlSyZeXF5gFcrtK3vHI80NzRyNJVhJh2muUlPDNTSMF3d4+yO2d+93989fn2909wg+3OydyUSXpByp3dxBXlRwC2aDkC6uJgBQEoM+Of8ZC4YdXhL++PsC8NnIV3bUQzTqea1JybcjtpgxZJXl+6E3tMFvUEF+G0hCIXuOI0R4auk41ivYgFz96NRrOVVIvojnszM8pMC22l+4JSkz/SQ7MpmPSCFIgEoyY+pq7gFIsJuRu3nOVhCJ9JVv6TYwG+5qI2eXmIe/C8Ub2eIglUfSxKXWWY7OH7VGgFEsN5OQ9T8kr4XQlvft2WHTHuXi35UqWc1Eld8F1V1EMfcNTkjohDgP8eyOJCel1Yx+Su+UFgSOvh+7DKiiWPdNeei1FBQ0vLhvd/uIpCQeBP2Fxrtop4i2ofVDJt7enU5Qcf4NAuL7uOuqysvCefHLbnKDkEaetzCnO9qZ8t9Kbs3ac5A6YEoMne+187EV0lTUlUG9Mo6iS8V1ykR9SciABJ6ORGt+HjgU0YZ9zldw2W7iQpaqkuT5LnnEKSbhBDDsY8IGbikMiIL+Wwf+YSOST9NhAezgeMVjnUZQGqIQ4yHL2YCCeJyUihnWxXXS0kSMHPdyC3InDD0SUlBhpyQHMBJJ2Qvpzh3Xb5j0pWT5/RQ/Eat/o6wxcMvOSAbwjQuwAgcLRuxGAM8s7FMiry9B00QMJiJ1y9cATZoGbwFcRwNpORBCgX171EfkkDbwRJaKZEYaX7nHsgcOifErYQdUZ5U888IQSpyHFM5akNV+SkbaPDYwI2UWHU9gH0pN6O1IS4vPDwaES1oAnWnLbVCVjPsm9MX6eRA/r0jsHj6j3oE/yP5PMSd8LW9qjOT1e4jyZHPEAVE2uiAB7F5YGMwuOd6E08EW0FPSJBTRdH3u8sYFCrq+7Tnn5Y0tUJQNfYpKXP5BYLm3CFSWGSDgY+R79M3vdZIksl7wykFMS1SPQvVKMD1OB0Kdd/qAXNVxMyeujXv7YClXJrVCV3ApVya1QldwK70PJX2dAh1uVC/IunrN/D1zosPNpIVTLd0BnSPnVhP3hBC03zs8n2g87JnfRof+LAxfbpvJ4/su/3378h0TMyDs1pMu3b9/Q1r0fFhhDHtu3Dxx/d/eBrsu1H45iP36HlvywQuM5n+Aa8suXLy8vZEjEY9O+YUu4vX2gj2k838vvLM7hXRtSTCgNfXPjPBpqvI2syO/rxHYLU5rbkU3TsBWxq7HxFteQUoW4JsKPL92PSgDs9/pwe//MP6ThH88ID/e39PI0egvz/f3uFkFKwMaOp6weOQeuIf/0pz/dNM3T0w/oK9gMf+1VDvwWPSb1OZxqyMr1MfoH24M/vgAlaUJOy7UZzlT/DEPaZwKDhwMjaRzsTcve3ct+roM8oJN49Gc8PTmmK9YnLLm8rkUNKe2TMaRydEew0E3U85T0zE8PjdDnz9SilJjjKRz8QGeITkQtCpo3ybd4ngkG7a7YPRXS9S5nyDSxNDTQZZI2OFOTcRybUY//TEa63gkMqeOeyqKoQU5ltEeiSu+3aeGSFCv7lNj5ysTwfs420xLHqhsGJsc3pDxElSEw5F/sG4rtEpiEzpHyKKV5oLJ31hR6uejnX3Q5UD6MiLFPc2wlPLIpuube77+j35+237Vvv/C7jxH5dHR+lDr069TM0kEvr+OLId4jnG4A68m5nCFlwIEzfhfTx80lYuy8MY4ZL4yha26xE/oCDMnPyf3SHsmc0xqSeh8/c8+ikuhhYA4ue2jNclquIbwWn2lZnlMMqaE0azLke6FnSIyN5fiewWtupA8P+r5JWn09C9LKt3SLclnCo9E5xyfkdbOXF15YKZ/d+b9+2isMzIHvkRiM5MUNmxs20ZAhSBMOdgZyYcigIW53eiOR+dSvxBS1aYjktdk5rIX3Y6ycFPPWUoxNk2XfqCHt0CYMYD05PUNCApCvyW1u7nyEbhuihgTikSW5ZFCD/rvn3/eQQLxGLr5fdkpjdKVx9rBwG0OO4wogAX6H8jAr8chBAiNFKEkTclquilANuRH6h1YcT9rIDM+l19x82ginnn2TtDjUUJl8+KJ5ZFGuYuTYOB8nlY8zyOLzSJzYNRQlbO6D8/FbIUgTGezkc9ENDgx1RWusnQCdXXe7w7ELFLYM2pG6EfoQnaroJ7dSJpViLjXQ2sT0ZBiDfGQlHOPYANaTc9lD6wLXWpdkyWutg5xlyCzbM+QlqYbcCJ4h28Z8NjOF19w4t4QH/cAkPIDiF87w1WpCTlcuvVzmzCSnrkFKkpGg+csd+dPhmJMlkopIGHDIM93RwIS4hqThJZ/mcwK7zY3hgKDbhhJDdpdODClD2gc7uoAZmHRPUWBcEoyePDgXjTi8Zy9kfaCXGnOltD7SS0kQ4BhKYMJdII00oF1f3pBFBEaKUJImpDyXNH3FhQyJFqwsjhrkVC7rkXX6kWuAs+gZ0j6mkKHX3Hx9OTynBiaJXBCwJzxLP1dLk3GGT8T04j2cxnjqTitsIlaKdfdKlii2HD3z9Yt1E2DEJx8f0BiczxDBV88HIdn4TGzPkWGA0k1Nz5B0Ek5/s11wmxuNiLQydnCJGpJakAerkiscm4Ql850jkgdt6401JDsE5tpbvb4jaeI45VCyoFgnhgMo1sTIbayhG3wCRl0QG/ryiZzKDQNzcJWDnUpINeRG6BvS3BTN4DU3nV6CCZFvktijHuEsqpfLXBx3kyVnHaMOV0jspg/zpkorq+VozrhL3li2jylkcJsbpw0eFgwZMhjsYB2e86OGpJeFMsiABU2BMEISQ/fC0EtwHnMf18ggVrQm4fC0j3qQIdEqyw52IMUoQ4Iij5TBTueRdAkJYwKO6/AMKbt5cMTPhpgLMTxkpV+SIIXs0sQmSwoSlZ/kEEN2m9jXjyHH4bo0RtUsGuyswiNLCIwUoSRNyGm5KsJoQ1bWSTXkRqiG3AjVkBuhGnIjVENuhGrIjVANuRGqITdCNeRGqIbcCNNfw63vNL889c30W6C+ln4LVCtugd2ni6C1VeZhrjvUHmrMy6IqvgPUivbLEO7HIWTXJGhtX79+/PjxJ+acF5dXPHwrWhN6VryjJ2SA862IgLu7DxoK0Nr4uQ35oEDTPGpU5WzUivKRBjgK1nCU33//XWIsxkL6uFQUpEkZUmv7+vXx5UW+IBC34uvD7p6+6fBwu0t8IqASQa2IZsVarIhWhrtIjEV98a55k8988Hc8YNG7XSOWExNyWOMlo6C1ff2K2eSXL1/kEy3g5qbRHcLrw8M9f7jj/r5asRy14vfffw8TiqOIrzw+PsouQZ3s2P+IDj14GFpR4ylg0NqCJ+FumqZnyNeHVyxfn3lNf7x6hnve0pdZ7rEpn1/h+Nf7Z0nlp5Qk74fOiljjWCpeCF+RGIuah32wgWOSU5KD3tFHkui/mBBBdkSK5/SK1sZWpC8m/Vui3z5//uxbkT6cc0sBazDA39fBf/6IzvODGI8Tp1K+KzorojVlgUEE2TUJWhtbkYY2LzcIwJw4AIRWtAH6hs4tmYT+k7HucVDXzdtbsje2OeClpBLeE2rFudHavn6lQygviJQDeM+KI6FTNRvvnXNpK1bm4EJWrMzKlq14mS+8XPQ7MgmqFc/luq0oP1dzAxH4B4vm/QyM/RmbDQTs5fUC6QSFuO27hxzBW7MmIVfL2SoUMq8VI7tKrLg/8I8hJ7Oi/L5VmbplOyuGJU9dV4qzrKivx8j5ov6qtIMUG/gRL0o+NvwuFNlGgN+WQT7K2WmH3ZvGtm/XmbgoZOQXvOSuCZfj+mLvNS+mLhs+HNsJ63U5y4rSOl0bJei97djqZjUM0GIbmDn+UrfCVoj4oinq7dhQR5kC14oMjOSK3VNhwnpdzjui8mkvY0VIjATQooOVoR6b/h22FNjyW2kopfl5t1qRXz6E/JI4g9u+JIe6sl7jneqX+E4t/E5F856kTmwnTLsmqtfldCuOgn/AT0x+MMkQeEkHJNHQ2WRqCZmwXpcLWXERRrXvyVymljyjn4FjjxpAk1bGoAY5CWpxDZYBI3lfkwsXTbo0rJr3IbjplzMNIFyTFed7J2WUha045p2cE1rRfBUli2vF/6H7e3+2m3bRpAy9MVPGhDTypIGajRkHspphXiE9K7bf7fibnPxlTvroKsL0DVb+GKsk0MDIpW8AMxdkUWmGEwZiTGhFMDwhda2I5Y9DVgQyX3TftBV+L8fDTgyaBtbH3IDDNGYfmJu6eFZs2U7zWpFfbwUd5VVlNFkKApQsYJtW5Fdy6SdtdJooi+4vwrcizCYfQ57RF4mo8WyAUgRcjxXNEdXGpOm9uHZCK8J+clxtjn/Hetc8TWtFshZpFzuQ2kCMaa04jGfF6KJJA+roRgMB12TFC7OwFcdQrZikWnELXEa1asV5eadWxNFSZgKFyI0n3UgjI1IkRmoJlOSy8OC2RxgTJdo0yOtmLy88Fe/VQnNafscz/qcCIVNaEaQmNBkGDS9W9L6zVd5dyhvaYwEr2gcY7PfVwkCMia046uIIkBlSHp0vstlkPZCLH26QIDU6PwNBAZbNBgYJm0by2uwUNoV7MfZLA4hBFMUkKnVrgV440MDhxBlIzcvP+ucwIfB8cTgXT5DDj/R5gUFc1dzSsISFl8RgHdIzADscmWopX0QFgmyWIOkLj6j2vDici63oveEfa7QOnVpMzCBu07ilcVFh4SaGv9LlCoAQ/S+xIopCSu6vlCMRCJnMitvjMqpNUku1YpL3ZcXKGlCDnET1xXOZpJZrsuIS9zRmJ1nLMvc0eMYq48lCePw2cEuSxpUyX6QxHo0+S3KVkxo6gkmsmClfiNTS8g3RBe8vhl+oHaDgeftw1j+Yiyx/aKUFscYInWKQR36EhTJMoNCKOvmDJDyjQlFcJl8MxK7wg7h9GTKEBkAWmd3TzPjys34g1ynG0CamQB0RKw7kajGzwuHHsaIJUBMDfqBDAmVWRPvZn+lwPi3TfTRE9mtMX4YMgQHoMBMazwYoScBkVqSaRlpRvKPUitQc1E4FueiJDXZAzShNibWI5wZkVxSvaWBwrKVMY8X0N42NDJnyBa8WZKF/XCCFw0CMyax4AdJn91m4jGrJWsJBTVr/a7LihVnYimOoVkxSrbgFqhW3wPu1opkJlJK6YeYiw8L+ExvxoZpFJhL0ne8SZIQZ0FNN0+gnvaPkh6OpvW4tGOez4PRzF4TkQ9s0HeIReRiwTGlFGliPs2LbFPxKXQf3LLcRPtHwBm2ygVSGYivSZaM051tRQDeV6no3h7O3iye0Ik1XR1mx2TepaayLTvu4ZFmjt9KONKbJ0BjcHrQyAX7fRlevJGlpeufhWbHnAJJLAqI4XcehMq21EKAYeb2HhLkveuYMDSC1wCMQEDlpLh4EKJFhMiuag8HwEdLALyOgyyBB+/WJ+eJAd9GW4rbWHE7Atr59fcWxjVxG8KyIXHytoP/SC13TKxukUqx7z2pwAg07AYtnANdItL64LxKjfBF4fSrKmedFTk4laKDtfgJH/83rKyCJJ3poRUDOJLkQRhX0PhYux7ls2z294VrRPMmRt+LBdDYqgHsW1ZYIWCa24hVg7DHIZVSbpJb3Z8Vi3pcVK2tADXIS1RfPZZJarsmK9Z6GBgImtOLopyhk8JmHJzCUjId2NDKh4eXQExvdrfkAb4goRCOjTUOjTSdxmDFaFEjF92qxT73wEAw1RQIxprMihuoYTZcOAAkZfOtGmnDWj7ryVoTtteNiYkVTDjSiBGiSij12+kGRNEnQZC5e+5py2Ip+sX5FVJKJgbQIyNwmJLQi5il2vhgGKFnAdFZkUtVkGDR8xIoFTwgA9treAxZqA5ls0Np/toOyGXqqOeVICV6xRTExQgPA+qHxbIBSBExmRarJHMoKoY4au/TloVakVqCGl+6dtyL8i9Z0GYUdzmlKKYfek0st0nuuQtYWt2nccrCExXYxEmhgC43hKz4UwDqkZwD2RTgwK7rIEXV+0mf3WbiMaslawkFNWv9rsuKFWdiKY6hWTFKtuAWqFbfAO7Uiz8EKZgAWnlFpOI0M9k64M9VLxmO8KN7Q1BJtGhmj6kYsb6q0wlogtDQhhB+8IWWZzor2/RDFpAbfHjpkZwWMFmmbMKbJnEs812DFblJYdnPYMpkVUTecZJQv7psRvujO+gdzqS/azy3AhLTI3JTtSav4kxaWsGmQRpZus5/XxqhDccyI+SKr1jSRyb4NUKKAyawonSVVTZT+5ZgkMV8cyKXNSiIFj2W4V+/6T1pInMVtGvchDCy9ZzI4UBKDdUhoALL6Ur4IVnRe1CYjj6PU/ccy7EVU+u88acFZOlzV3IcwsPSeyeC8Xcx579hASmlCysGhMBAypRU3xmVUm6SWasUk78uKlcVRa5zK8Fmtsn6qFbdAteIWqFbcAtWKW6BacQtUK26BasUtUK24BaoVt0C14haoVtwC1YpboFpxC1QrboFqxS1QrbgFqhW3QLXiFqhW3ALViltg9+uVoA+LVSrbpXpjpbIW6vPhlcpaqN5YqayFTc3+P336pGpVKldI9carpB53Nonvjc3jy+PLmy6P2IwvN82LZlgTYR99hBp9vnz50jw+6u6rpXrjJvG90e2+//znPzX09vbx40cJ/P7770hzc0OvLYnQfri7+2Dfa9MeG3dzBFJOv7RBUt74888/v7y8QJ0f/0ExTVO9sbJGfG98evoBfRcdF+7n8tNPP6EfY40ECNzd3WkGj5Q3th+aO3on0O6ukd1I2G27uTo/bEwW2tVLn6Dk3AiHVLd8wSjg5fPnz5o0yuvDLfHwajchgt1cjuqNmyR3boQTSgDnQ/jht2/fXv79hgUOWeSN7ZFc6th5kkG8Df/hWkd6vXYvl/VG99zYT58g6o3wNzmgADqmvLCCGIU/YsRKJ0yc55M+Sd748Pp8Lw5I/585hnfdk2vCOe/FO8VV7ba3SZl5m2KeKcIp4VY9fKhMS/XGTeJ74/fff68h9kz4IZwQwAPJFV/o3II0hSNVfgcg/JF8qTsnUgLESzrZpmS6X06nEt2V5qWnqJDUuVGOI5gxYm28sXlrSIXm8QZpbppGM3iIN9K/+2e4E9xIYoyXGEzULdzm+dU6Y7cpnmYySXLxQN5VVmZH9cZNEvFGPYc8vsgCP5QFYewVkt64KClvFD+Uo4nEkCs2N7/++it54wtNgzWDh/UZ8gs+pWkMb4s3aczzvT3B0Xa4aZPLHi7hmaPg5zbGJIqVSXuE6o2bxPfGqybqjRiLYi2zRCw4rFDS5gYLDVMbPjemvPEisKvK4LWU6o2bZOPeGAJvhO+Fi+6+Eqo3bpKteWOlcr3snv/6t7rUpS5rWMgb9cwyD7/99puGzmOqckq4ZF0ncxVCFrIqXRYUpnpjhKvo6FchZCGr0mVBYZbwxpa/6aUbTBgTEGujY0MfFOMgSrAf5PMYX11c5h19XUxzFQg8N6GQJOOevqLHG9w4R5ZzBdLmOdG48+gVE+ZCLOqN7YG+1EefvaNulG/WWBuxlejjjbodZ3x1SZmdojTAHytk+NN9FN80HEeuIB8iFP8wtSNiQNUyfCGtSC4ij9ZLvml7NT1vET96LUCpcSOtPWCFE/SNCXMhlvNG25Q2RsIJ8m0kZ4J4CeOrS8pMIVi+55b8EVGmH98LYK2JBNl3Fr6QtkYXW7vZpZ1yVb5Ybtx0a8fjT9I3L8ysLHhuxD80kTTmKedGzq+5hr1xTHVpmQVUJg5FRpZY9IdeP/ADVKdN6hR1OvEGGR6pyqeHJxBgQsqMm2rttBWI0fpGrH8p6lWcCAvao5xThUTvXNNpkZmzwUfru6D1qzdGWNAe5VyFkIWsSpcFhaneGOEqOvpVCFnIqnRZUBjyxq9nf2E+Awr/13/+e/6CmZqWOD+zNshUsJC/bGNZT4MvK0n1xgjr6RwZWEi/W1/psp4GX1aSrDfSJapzZ/wo3POr3vLyv3/c/flHLzK2DHhjX1S5jkZ/rvjF6qync2RgIf1uTUv73X53c2idzf13LYWfmt0fjhLpbnYJzBLGzLykG/xIl68VvTAaGrckppBlTZ8/N9K143HaBKBwz6/6y1+m8UZX1HgQlKozjUl619mnh4X0uzUt7EuH5qY5dpvX6o1hG4bGLYkpZhrTn8oGvdG1YN+apeoMm0TKxVoO2G5A4u1aM0wPC+l3a1qMLx3FIa/fG+kOaktnOxjPbdSwmVMxEi5h2PRzUs+NERINguzm5rpndi/g7Z0HFtLv1rQ4vtQebvbNH8zm3w/72Ah2zd7ooM0ZGrckppgSSeZji95IG9FpQ6k6qQbBxBNlAn3S1XNCGzAdB2fM7kHJqWEh/W5NS9+X4JC7bvPvGMHu97w0JhLpWSmleYrEaPa5lnQP5HMi0T3dWzJLTHSAYdKSXIK8N04ACvf86rQFBtES52dZkxTCQvrd+kqX9TT4spJUb4ywns6RgYX0u/WVLutp8GUlUW+cG/jSJOtKZW7UM5bgEudGDZ3HJZtpWZMUchVCFrIeXZaVZLve2AINjmU9nSPDVQhZyATGLYkpYNlWTXgjXX2Ua1gt/dDsjMuCSfVGVpFuJsrOmDL0kqYTmqyuBF2NaUrSjKFUSKk3Vfscko/XNK0LLCf2Mg9SdYWbUElMMaNNPymD50boM9x9MxSoV1TFUDnd3QvXAoE1zqiLypL3OzRHc91dL6Hzru5NGxrTF8KNmYJkg0Rkc2oflDyRRl9sYZL4aYC5/1PyXhWPlC6o2bOW1cOGS2IkXEJBd52RnDeSJqNUiZFXr7yKoWYa9sZz6+qXlXr1gybLx0xBskGistnaByWfME0xmR7oDWrcsiVcEsPJixjqZvOS8EbVfQIynWZUFUPN1HmjYwETmqSurlh34Bu8+kHDThqcRrw0U5BokIRsoVQlkts0XYw0ZJBG91AUhWyZZaSNSxXZUqlm/NfCTagkppihbjYv9SpOhGVNUshVCFnIBMYtiSlg2VbdrjeewbImKeQqhCxkPbosK0n1xgjr6RwZrkLIQtajy7KSVG+MsJ7OkeEqhCxkPbosK0n1xgjr6RwZrkLIQtajy7KSJL3R3E+yN5hOJKPeqCoGmoku7XXFcMl0AT64PTZFXdMy+rKfsmy/mZaULmgbtpqFrJcw7kBMIcu26uC58dTOYihQr6iKoXL4UnguKExS16RUbyzTBQ5GzRQatySmmGVbNeeNcmQ6yxeH1CuvYqiZumZ3u7cXPq8uUwUV1BzDaigex2KOQ9+hvU4iDQYxTsQoUg0CKaU8FOz3RFsjkoicFmdXXwUHSZNph1MZMi5VJaq4tUm4JEbCJQxKMivD88ax+niUqFdSxVA5zkEwHlTOrauVL08lvDGM8eqPxgwKFCMtpJRoi2X3FAeTyKJdVrAgDe+Mt8OpjOiBoXFLYoop6a7zkfLGyBsQTiPTaUZVMdRMvWbnkt1pwzR1YXKqpXAh6CWyRQ9xIqrXWU04rNmLObU35xqEJOsK7cRGk/TlzOyygvlp3BhsnSq/S1aX4+HQ86fAuEUxhQx1s3kZPjeeyVSFX7KZljVJIVchZCHr0WVZSao3RlhP58hwFUIWsh5dlpVEvbFSqQjqGUtQz40RljVJIVchZCHr0WVZSbbrjSc9wi+sp3NkuAohC5lAl9DcJTEBy7Zq1hvp0pxzbe4kBtQrriJdDhdBmMtn3VU+Ezrae3BFV7xzDWJlbenlxSWSl+IWXkCJkNB23AV+y0hheoR5h0ob6CQCCoEuWEMllEWm5EK7wk2oJCZBkSSzkfbGI32heUD2AnLqjaliqJk6N3ML9AvH9lTeSJhKu0v+9jZGP4Yy6rssvMvwXVRXOHZQw3CiJANCeo6YrKsL478mwBZFjnhDx/4gtx9ZbCdes5oqUgwZ1y3BhOhGUVyVkhgJhwxLMidxb7QS50UvIaXe2CqGmqnMGyli2B2TdfnFcaVUpAv1zEhMKBN5rEmIGCqHbukNy8fkhJSTBqRzKvXrcnZxmLKh/uZwpOFcJEG6EC8Q5nVjYgwb1xwQurpMKF9bKkbCIUOSzMvAvDEvegmD6hVWMWww24u7EjWEf+Q1GjORN/JIlYviMsMK3Zh+BGcjgU0Mu43m7VLkKRMSRWEjqMutnc7EEmOrjx4+sgK7Aaw9ZW2CBFnj9jNbMU3Zzn4TKolJMNhdZ6VexYkwfYMM9IFTWLbfTMsEuoTmLokJWLZVt+uNZ7CsSQq5CiELWY8uy0pSvTHCejpHhqsQspD16LKsJNUbI6ync2S4CiELWY8uy0pSvTHCejpHhqsQspD16LKsJClvPDZ6JRucdf0hrd64KgaaiS7zddch+cZY7wc15laZjciRq6s96DX+/b7/Q58pGHOxp7TfSJmpkktqHCMVMTZ9VpfQcAnjDsQUUtqq85DwxvENmiKp3sgqhpqJrr9bU8SCQlGtU8mslOcaU35pv5EyUyWX1DhGKmJs+rQubkkIkylD45bEFFPaqvOQ80Z9/qjk5leafM8ur2Kombpm90zohukYW9BPcnXpb95jJUllVA36De+DZhKjaWmf7JJQJ7buCfJSKM5wv5F63bXuYGx8psYgDQU9U0ka3cNpoJNXzhAZXahzUGMnf9FdEiPhEoZbdU6G541j9fEoUa+kiqFy4sdDJ6hMUZcgZXPXk94sRbsVeDHhLg2n3+4h4RgJIRPyaGkF0k6WZgQFDY5C2ZSo2TNuSUwxZaafi5Q38glLDkrjGtYnrd64KoaaqdfsXLI7bZiqLlsOF80l0eNiEoEK4/1SnpRjUbrUmqYXMaZPp4SMy2NKK5A2loaDHKWJ/TSSXWJwErNllpExbmc4Y93AuEUxhQx1s3kZPjeeyVSFX7KZljVJIVchZCHr0WVZSao3RlhP58hwFUIWsh5dlpVEvbFSqQjqGUtQz40RljVJIVchZCHr0WVZSbbrjQUP7KdYT+fIcBVCFjKBcUtiCli2VVPeeDQ/HW97D7mMJ63euCrS5ZhrebaM7jqhCaEqve5XdMU7WVdXMkEXWKMXD/vJihifpbTfSMmp8kvqHSvbhLqEhusKN6GSmGJKW3Ue4t4IJQo6bREp9cZWMdRMnZu5FvCtUVZrsq5+cZ038gV1hq+od8koRXAnxPklrt2mLMGbL7IkhYwKY0WK7B3xxo1ONC8NMAp29zyKyehiiqJDtqsHR/U0y8RIuIShbjYvGW80rXCeY6bUG1vFUDOVeeOZdfWKpp/HOx3Rdk7uDtwnu5ooxkUTIVXuzRdZMkL6wth1aq/JOHGaYoaMS4hjhvWUxEi4hBJJ5iMzUk0+CzWKtHrjqhhqps4bHQtoSCowMWfU1ZUsSKW0NvX1u0xXG4d6QiGXTbSPvzgnS0LIhDBdpQlROSqZxpGdFQrS6B6KopAts4xkg5t6aKAqLalCOqGSmGKGutm81Ks4EZY1SSFXIWQhExi3JKaAZVt1u954BsuapJCrELKQ9eiyrCTVGyOsp3NkuAohC1mPLstKQt6owUqlsijVGyuVtVC9sVJZC9UbK5W1UL2xUlkL1RsrlbVQvbFSWQvVGyuVtVC9sVJZC9UbK5W1UL2xUlkL1RsrlbVQvbFSWQvVGyuVtVC9sVJZC9UbK5W1UL2xUlkL1RsrlbVQvbFSWQvVGyuVtVC9sVJZC9UbK5V18Pb2/zKIYlcHvpUfAAAAAElFTkSuQmCC)

Suppose I have to display name and salary who belongs to Allahabad

We can get this result by using IN operator

Like

select name,Salary from E_Salary where City IN('allahabad')

output

![Use of IN Operator in Sql Server](data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAAMMAAAB7CAIAAAExg5NzAAAAAXNSR0IArs4c6QAAAARnQU1BAACxjwv8YQUAAAAJcEhZcwAADsMAAA7DAcdvqGQAABDfSURBVHhe7Z1Pj5tIGsb5Th1Hsr9LK+4LH2SkbeXWPrXkWx+ikSLPXrIS5xxHM5b3GK1QTlGkVSsrJXOam/d5/1AUFAWFDW5w6hfifimKcvHwUBS4jJMvTXw/ieTo5z+taAEWVNbHjx+fnt7x6nl2PC6XD3gFWCyv9+sFZ+6grV5YLK82yWKtkUNbWX1xyso3OU86W7BabTBtcp1tJNH6MUkTusxCV3WgrMejaH3EmrdvXr9a3P33f3+ZidJTyrBqr1VRloKy7FJk0mUBUFkoQueApRQEkiBLVys7j4d6WVgNsyglYbFNYmhZGp5NvSzUBZVAAF9IiqGf9mfSrUI4g5alLVYVbHhfvJXSJsqDrm2RoM3abvdYk/yVP6DZwoRZLHt+fr65SREs1t4WxuCtEZbdpCneQ/J1Mpje1YLyzSbLzbFiSJMVJp3xQM40QCYXXWahq1ap1AiNCda8ff/Xq8XbWvNijpXQgtxJlxUEFQQ22o7WMW1LaEFZTo0BSsNqtuq9C+okeNNWK5ysILndNEHpfmKHMFhBPoYrCFWdGrRx6XaP6SalSWvaemaTNX/8+IGGRuJhofd+fHz88OEDmksE8q7gIT8my3QJU6HZXD48LBPEskjWRBuK+PPnzzJ7oP/3O46TZI0u4f3ucDjc24n8t5vBTDAgP1WdslSD/nj7OrB5rSH3TboCY1o0u2nzvYUPU6f6KUDq9Du/K85VcrqyT1pmkvxpknJvm8623LaWlTq5TiMydJ3yTE4oK5z36MSHk86Kz4MyW0KnQs5qn4SEK9Kpsl0WtO1yBDlXkDVwjcOWnJ6fhjnu9O+UmGSd9GopAOyCy0B+mhqn7Du9POyPvmcXVKdahw79pCRZSizIdacBq+F1/42CMSh1Qr9RAqrTMkWfLj9my4QaJ66TxgCrwV6//kE1k1LQcaMXic9G64QKyXsArkGOLibFDzkqiBS0h4glA1bDK3QCcrmOOi0WC+pVUkz9yh3+He5RSzsxkFP8hNVwzU+X/fu91skDFNeoD6fUaWyut06m31LrwJxGW51gaRx6dGeZZnw3IxT0M/EqdcKr3OI9jbH2Xa1b1wvvcUENZxi6gh99q2C8OtUuBFomXaHA7jmdhtbJ3fn0fvu3v76/u31Pd9rMpYs76Qq8v2SXmeA0Oup0m9wlXBUEXXUqe71FcCLD77vzGeu4Owetk2/3w0kadZEkK1ziIVgliQQno2+JKyEJakidTEuYZqh6tio6LTbJKh3S41lKzYzM10B6vkmlxhvUZcVVbHq/4XWaFJOtU5bKGbQR2U/23hJ71cmzgdsneEWCRuCqFTLwfXy6oWJ9/GkzpMeHZbDz3aSIdQoj1imMKd5XmSCJ3oUZGX232aIOlw8VZZI7UeZm1CDou33//vHjxw/M09M7TZoDKpOMBsE24BXb8Pfff0uKobhPl7VcbyNPka2Ovtv379v9HiVDo+YPbQ/3yZpuU90vkqFurw2CyvT4+AiNZBtkM7bbrSwSdPuz9JjrSEAiz5IklUWikWbjdAoK9N2ca3S6r2bfUTvcH+jO3o5f5R4fzUK5RbJeJ2vM6s0+zrDeSa56TskyIKVMqK5MywJZNAj6bsU9UBzTCJ6fn7Fv6jJZwXqRyKhJ+ksCrtGd1NnFAhkQIHJzUgmDcqGzr77bbLmQTHNnYjLxZZp9F7f5GvLinCpTzrdWslSv4Xj0M64uV8mKYv4vL/2gtj8xq9nXtBRz4dCw5WJ9JE6XibaFX3n0H427oxhbxQENXl713piMxzxDf7qtBFgmO+Y8L3AExLYpCDq/ahgG9mvt/vP5kxZ9Bn23oi+2TDkkaOlkCz6Z3A8WfB81uJMWzeAAQ03STBpvOoDdwOWSMoG2axGhlGn/lsay7d8iJbGGs9WCkEmLZpKUtCCZWA9z49EOKF+VC8vUjc9N50xatIM7fMp3d/Snlimcyck0TS4tU77p8aGWdGQaaVzUkt8gTQ/aJhkj0Ri4XFQm30eb7dBQY/72DlQQITSQk5K+0q0VsxSvrVATPl2Z5sslZLoOdIPGYdJumm6HoHEwhQ9pZXK+T0DXrHp7ANe91FSZq18sSNE5XNEVbGPLYsPtI/UkTWfSDShflcvJhHMc3r/9w/saRWOMvjt9ZQKX8nqfgLTOIQ2rRovQpAe236RoRmJyTlrfDVwu7aaZMrpM+jfSSpQpiChTEFGmIKJMQfT4klYgOOlcGddzpTIeUaNu4uivbi7RbKtOF0c38WxUo1GHx5nqmrFxQFLGY0SNjEA3N5ZG+QNd7bdfzefF9zYdTHVlvN3+2/HXPyRhRIbXqMaPHz8qI76K7W8bzoA8HplsjeCgp6d3vjGWC/362yFZ8Fdez2BcjSAQdnVNI/FRlh8fOH25fCC98odMdBGBONZ0Xk+wNXp+ft7vyUdIx6x5Do2wWNzTkLbdGoEmncrwGu33e9NYyADLRh/hYDNfzwYP6dLVSNM5EGyNJGULnfhBPZVhg6wRpjW/4r+kFOMqK4MnOQOZriknMZaPxEGyn1F7TQVm4yEcDzLCfA4n8Ve28JqmKQtEH5CYdIOtkbyFiIUYYskiAdt5uF+sdxTYY0khG235YZfQUFRVBJMGbs4xNKIBpwVmEKosOh9bIznW4FOkf/r0CSmySJDN1oAUSXDoVQaeFuNQqcE63BdBPScYy0cjYWv05s2bmzSFRrAqZn2NdwhotUSaRuaq0SWZmUZzp59GX79+1Wg4BilzjIoZokbdTEsj+oCTP9dUmj9ha+Cn0chVZNYa0YB065NYBDJEXT5i3bAXzNJ27M3b8OfiOgOBjEYc07N7qZffMM5zkhrx9uO1MjqJN4nilktfB2fz+ONyHgbPGtkxDYBvfILCpDWqjOEvNKp9KaIda/NoyLQMryA7ma8eWDEtaip3ihoNSK8yoaFGVaJG3Yyrkfa3Z45uzTj08xFqUxuHff409haez4Q1Ch8EODKlRjhjJ13nbK9G8nWT9hTPVNWIxrXhVCmnSOpnucHFqfio8xuKtkavFndJcveKTtevocgvb15LIN/N+f0kjcxAewloTKIT0OLLco5G9E2k2wWkSVQRI80ZGrFZElcaE1C+y3KmRr/9sv/r93/cldJIyvsiJWCyNaJONo06nfCx1omt0VBTVSOLCbbZIVxUo8kQNeqmt0YaDUfUqJs5aSSPL9AZD7XtoRXCTzR8YnKplYkiZXQKFc2RG1yYuiiNd2cMle3xbDPRuChAo7ITxL9OQU+UcIOLU3lL6qpp2Extn7u3VvUxJiwHdXPwBim2K8XSzCyV/AUNPkobuo4moEyXpdSI6qGhl9r2MLVbqyoWAnOvEq9QExrpUrxauGWSuNP0EXYg6HGseW6tsgo0gAQBliNF7ueqOl0aIefU26N2mnx0LmOUOSxRo27ivdpuoo+6mbBGE7zupy9K5w0fE9tUtqc4Q8nZXbDjCs7pzFApk3tP0p9CMMn7R12/ruLVCP0WPmezRhn1FeUxf/SX+5n5ptLhtHA1QlfB9BjdgLJdltqxRg8DaaFBI/n2uT6fHnqspHtDl3JFUgrlNbPKalMpk4HgrjQmoByXxTrWeFt7a8SHhtzkNZ/6owy5EMEsD5pAUphG7CPpfyKY5LHWhbvPz8db5gTb7BAuqtFkiBp100+jn5OoUTdRo26iRt1EjbqJGnUTNeomatRN1Kib4Z9bMwboi0cmzpXc9Y+8ONFJkWG4nh7Ai3xPPmKITpof09zSipPS7X67P+q0xWzzNOADyQbE1Veek2Pz/Pycbpt+5XJWzMBJtvR//vmnRsXvmQL5PdPKY5JscvpBTvN5WJ7Rb3We8vGYlFMtrROfkz59+rTf77E58tSc5t9LnRUzcNLT0zvoDtFhHRt5HBlekQGB92FSPiflD+mSxwIsU1mMjOW8vVbpobRYhRZV8nsIaZNgJrXUHq1v/dlwdQ73C6J43hJmUYUxfhG1JzNrk2AgCdAOwUP66LZv5LYgJ+UZ2YGGXagLCsQp+AtbZPSJfmUt4yS7Tarm99DoJHhFDgZAxwM/O4/O3Fuc5aihQvvq9RM56f6wW4t56O+OU3gRP9QLxlqLs8RmZr42q88AkxR5flxZwkLd2VWmYQZOenx81IhdBQ/BQADuMU8AlF9c1kw1bE8QWUpDeMgHZVtEGZAu+WSesulyacYkuSytlp+SXHxtkhwD9PS8b/oURtjomNImpNsb5LlJK09kLBEn0Z/1DlaABSSl2MMFRdICu3x3MEYqZ8UlxUqSXdzDi8LKLJmHk/TY5Z8vxwQPyYQYSwWvk14Un5PEQ3IkSArZKL358uULOWlP3T5doYbZ37RPuSnRFJ4XJ2jKbm0aFpp3Z012WcIl7DgJHjUpRaamMmmJMAMnzZpGJ+H8hVfpFWHCIUFZ0xtMdGpLuU3yOekisM3khBdKdNK4hOgLJ8E37qSLZ0J00rhA38gLkuz++a84xen8adw2adQHzQ3IdOo5F8VcopOI6KTziU4imuqZpeZxCDl9Ta/ha21Ib39iQn+ik5qp60LSp/zFUlA8F0IeqmNSOE/KaatNJt9CpS+o8upm1WF3YNP+Y/tsqnfVG6rKFfFvgnGg3KXtJDqpmSYnFR4wMfnD7Ah66otJrwR41UyCLBuG9v1HN+GLmviq2pxuDBToo+gkHwFOIo0liR6DY++GeoA/ZdaynCFw95/1ZsZJvqr6N4Hg9qqc7SA6qZm56DJmPeGksOaIiU5qJjqpL9FJzUQn9WXGTvo+5mMdUHjtib/TnNBR1hq/KKPui7GJTqIpOul8/E6i65AeXcVGejtp//bVouvHA0Ly9JzanFTcKzL9ZrkYo/99UkK4UidBjegkvf63sFTRMCQljOgkL81OghWS17+8/3c9Ef7gRbey6P2dphjfmDyXchLdGCpuVkvrYt8qkjgkReJOopO8eJ2kVvjt1ljKdUlIykBTS5tU94Tb3oSkhBGd5KXLSfQ7S/yrXcmrxeuk0TeUh36yKkFb9cZppQaaULrW2CX2k8JocdIANDtpelObky5IdJKX6KRezN5JY4P9NIvXKaC7ZYaQghqOwFykmUg9o5O8XK2TcqChEpLSxdU5iS7a5NoXV75nXb/5pcF7FNfX4W8SfnOm122clnqaavJXzqmSZclFFJISxtU5qQRCjOQkLrl7bKs9VJdW4ZB3DQ1TlFmtoFlMR0F9Xc7hp9tJ9H4UUsGFNSQOSZG4k+t0EkkQroGHEGm6x7byosouchfRH6wF+8jzT9wMbYTUU6rpFhySInEnV+ckbP3Z9ySFFpsGj21lJC5TpIoUSmSfhyhT5qwrsQfvLiwqRZWMZ7dWYo+b6F3PkP61m9JFdJKXq3XSOEQneYlO6kV0kpfopF5EJ3mJTurFFTrJGUlxIl5pcE3Db1DgeaN+lz7MCau07kJXipAxJG5KCFfopIKTdotFm5MqBdPVdoPkL+0kuzDEVEWrphqGpIRxnU6CcHQknuOjdifxka5gH9XeR/ahvuIIt3doEWtY7CwqU+6EF8XZ67XSsgu5daEaplyY9faVOranSNzJdTpJ6CWES5uT7HLLY3m1KR5LovuEzCF/OKcVVsjlqSbspP67MWAXFm/stjchKWFcn5OoEdC24gwbgVAnFfPlh2noY4iTimy0JyV2aleuxUUM66TyzQpDcErsJ9XpaJPOZC7STKSe0UleopN6MXsnRSaC7pN5MomR8JErIDopMgzRSZFhiE6KDEN0UmQYopMiwxCdFBmG6KTIEByP/wdF0FO4buNEtwAAAABJRU5ErkJggg==)

![Use of IN Operator in Sql Server](file:///C:\Users\MSCLIE~1\AppData\Local\Temp\msohtmlclip1\01\clip_image002.png)

We can use IN operator with NOT operator

Suppose we have to get those record who not belongs to Allahabad

select name,Salary from E_Salary where City Not IN('allahabad')

\

![Use of IN Operator in Sql Server](data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAALIAAABpCAIAAAFmFt5FAAAAAXNSR0IArs4c6QAAAARnQU1BAACxjwv8YQUAAAAJcEhZcwAADsMAAA7DAcdvqGQAAA5QSURBVHhe7Z3Pity4Fof9Th0H2u8SUr3xgzSkmF3XqqF2WQyB0LmbueB1ls3EVJZDMLMKAyHMQHJXs6v7O38sy7bsksuuLnW3PlSu42NZlo+OZMmyq5IfS5Ds9/tPnz5ttyWECh8LbM7zrcQbh1JBEre3t7KnDTbLcvfjx2q9W6fpGtLdavfjjvdtSO7+89/5gfJikyTZvtroig2U1SYvdK1DN5XjoDIyB//2z//6gSIhh0PZYDiVvcbAPi+S5EX6y7fyA/Y0qWw2hU8qc6FUqk2ma/t9lm2QCwDfyTJjtWKTZXa0DgvlRb/nEVQqsMtMEtTDjx8/aoLM5eUNlthWlqVEGidBPX779lfZ2Qbbyr/3+faCYu1QjVGDd7sfO6nWpKxZoCq3LQpnQjXZFKgqqiEqUsL5Bhx/gUJpJSGVTQLVwLru4ejIh1Q/nDzHbegmcf/mJZbXZSsJ4JuEDz5JFJtig1oL86kCcFslFfeBcjGZx5sEzLE4lA+p8b/99lur0lY31CxfghsJkGWL7CmNBK79srq7W63v1quUmiDU5yRJ04RkfBslxRtglj0uLnIEXZnHAkW7CKP54J4H6l6FmpbRt9S7PtheFbnElKXpB3gyeKWVlscn6A7DDB3CxuSjm305xjtuUKVBvE5fimDaRwm6g1iFmygjCJPy0cU+0njQHYaZkI9Oj9sAt8AFT1cs3PHRjU0y2gQvQb9LlDPt4WQouy2qOlYteOVDv89NzEcb8o+zc4wxdNflcGQCF1U0z7rCSFfbgN2wfPe7pLAATSbQERdwSFzdcam/qYBqqPLV1RC7/fnnn+ge7Lc5BEpmt6YFkktX2BGdd0oaK2lilBRtAMqE9DacA34n2A3LstzvcamXaz0Om6wweoCArsUqSde7u916tbqjIYUoR5jlE0t1OJa5YzEzHGMJm7/++kulGYxlYpPTNZrucuQ0XsNC9DaSiXxD3QPEge9KfN7oy1gmkGK1L3ClpGqBr42pHw2SCSumxsfAUyL4EHZxdPoyQwG+rTvMQDPR77B2DjYUJBPo4dFAJiFXwPhYBH/GM/HhRXIF4UWiXU7T9zTBWELuMXS6nJ4csMSLN58TzgECzvRb+eG6bHKAYBfHXEv0sY80Epb0iaNZLhMYV7kaokGsIVqTiWpTUHNRd7tZkC0H0WP3WyEDWh/2/GRT8K1qHMOVCXgV58E9KBrnSAMY3MXhaFrHCMcnzk3MRE3MRM1zygRqcvioLfJtuS332y2EJiyIHs1q2/Kt12TsQ6K2wFDw06dPHxmMDIFMKBtkXIzBMq4MOQarlzRqxpUtv6lkE5aXlzk0iCB62q1Gj2bZguasy1KHswaeXcZ3ikGtaB4QtYWMiXH+P3/+hF0w5O2MkuWEcd0u9hWdZ4VPgQ8bgOzCtqCAOKLn+IoejW1R/l3fB8jzfIshrTWmpfm53d3dioTdmroRSQIpSVOMr2novab59xXd5k8QgezlinkcD91eiDsgkJbG9vVNhmPZwXAL8UC2+PIYeCBbjLDI8HoRgrIFTwVjNKOrJE/rxM/jWFtILnmJ4RHaLYyQIGcZDZggS2Pmcyodv9BLlZWmLRd5go9GXZpHV0dwITsVsb1omDZVBzr3b+aHqRlwskgiHVsc9sDOmXiGzr1AO/RPo8gzaRRM69ASXARgC3qK8ErOU25AqsD3RUk2grct9PZTALY4TOdM5odFTmMxWzwN9IRmMNkvFudwBsxd075QcxJbTLoNTj0rgloZmc3Digp0i1o11FXi566l48S7NPRPg5Ol2HmWd25j2wJFrVnaFnbn1w+xBZuv4oe06KOCPK9FOaaeNU0jsi0yHuDb9AqDT5J7n5Qy70XKvmCxtC3OxCIZWMYW+h2JtrCJtmiItmiItmiItmh4On3w+TyEX3z58kWPFjZP1hZHHFRtQZOpZWsy9SJvzSHOwWTLzEt+//5dNKfjeFt0+Pfffy8urIEDzRgS9UyiC8Spo3WwbfHHH3/I27+iOR3H2wJZlIllgIy+ffvrpT0hatuCX3nCenVDU8y6iQ3Bc843qrfo+8W7338gbHtvSqZpKlOkCc8wz2EBv4BH/Pz5s/wbp92zRVXkxZ4eCCcuccr5TWHbQvxC9Ra2LdTcJT3ggNXOZGqarulh7RVssiaL0HQxvtMkkQfJE3pX7I6eIl/RG6I8peyKCebawhgCheasIzlO85J2gYPkVPjYQLPqNMFT26LW8w6MbQukj8aCbUHpQyObBJhgna7S1R0ZhU4UkMTT6/Ucem0CfTrBEZM43hZSNRBQO7C8vb1t2WIeti1gCNgawj7Pv3792qkm4g44GzYK9X0grKiod3AXlDwMsEpoYh0nbiL0YmJtubZzWWxbUCjJ4vv8YpFGlGuLg9BtYYAt4HcSVLU04driURDECyuBhGl+Ec48cIdFMhZt0RCQLXJ518OaNKjnXw5zTltkGT3KSW/MFCqIZpNneUHTISRb3S0fNlmi82FNmptO+rKRI7U4ry2oxGgpjyNlG5FxLhB4ooy0EnkS9FpaO81Ghu8Ue+fvogRhC3nQtWMLmYiUOP4kOcVHUnaarfRpCpKeK+5zTlucC1RBldo8R1sMEW3RcAZboNPeeapmftCkAyDaoqFlC2m0RzjSFuUv9x2NFTRphi6fRF7ww77Q9IXTEZYtBFyZpRNhehO2cDqOt8Wr5Aon+U7OE8vyl1fvP397f3X/z2d6qZr0tTDFFvLwEf1YEy/7ApYnYpZfXL9+advCCO8kgiX420LO9pH5xf2bK9RsCFi+en3V2AIuQ7ej6SlXFfxtUem5nr+9OMiR7cVo0KQDINqiYfIzB3zNWxJNdx56NvOY7BcqPUUegS08HoFehsYWfPugGr9otWzBdyvQ8nte8/1vZ2R5QXf6KnpgmPeiI/WFxen4xXRbyJXY3NSrBbklR4nZN+ywQj+ZMgonu6Fnnekxc9PF6gsUeVFatjhYdEO2wJWfoS6ACpwULc1NugSFPWppRu7WmMLvm8AIWC5LY4v+U+t9nHUEJ2hu6hlBUsPJS//N3AQ8ZAw1MOJDrr2JjdITFqdTRw7g33ZyjpfhDG2nD/62eIxEWzRMs8XTJtqiIdqiIdqiIdqiIdqiIdqiIdqiIdqiIdqiIdqiIdqiIdFnXp8EGDpGFuHpVBF1jeeBlt7JaLlFvi2d4SLvBt0hJPrGkre55IdZDW/f/qqbHy3nd4uON2i4GHALfv/Q4tJjAsAF0rm031bzom8seo2LkTfo5CU6z398DZmHdgtjR4B6phL/Rw6W8oYi4rRe1bTpFidNjBzjGJLOROdwusW2LJF5CGgkJExwC36903qXTV73lNf6zslDuwWsplLbLWBWOITUOcQZcwtpJgQ0FlSqVvGqWLsLxUccq/hFtpekbccnjQOnW3z9+vU7U5b6nrTG5pO6uKj/XsoJ/zb3elU7wt0qXa2geXZucXt7W5bNC9ZSz2SJILVtu936thZSmkNlWRX86ruPWzAmvq53cbqFbquhN6Vr4BAX+egboewWO1mSUxhZv5o49EY5typYJaGzatGkgA2cRKMZT7PhDG6hEl847BbC1Lax97o7BWnWq4IKlNsP2Sw/hkAKXkc8Wcvz3HKIgtXkB534TobcAqcgb4wj2I4CPTwDjnLALeQ7TalkRNMrJ2XH/11rNjWrKOB0bTtBnXJL45Mmcwa3QEsAM3WWtiDoDiEx5BbqE+UefWVzlYRSfuoDcQ66RYPR0O9RsJ+m+k/FOy49Usj2odU0NSrRQFVrDqRpeGi3eNQ43QKXidevX9PFgoO4Bdo8NBLYigDNoFucktoFGifwJ7rFBB7AWIEQ3SJyHk7rFsG+w2oTVCYDyUx0i+gWDqJbDGSy2uiT/VnmfmwdEU7wSH50i1BwZNKnyKNbHE33JKkK8o8JAXrZtm1WMTTHoQ22QN/61cRkcT7ukqgK/mMMai66R5Kj9/Ng9NiFfzCpfllowtzQc3ULY0qVYTI2otGYOB0BS2/jTuJQSUihDuVzOP+Ad4X/1+uHiW6hsvxdDdXKjFsHE8chwMISlf7eZSlcJWGORMeqC92dz8H8M+w1E/L6LN0iSE6VSXgEfGWi/0a3CIWgMhmKW+jdzpOBGvMoloGgxXJuyCIqngAkDqN3fv4ltIAcanbPTXSLgMJkt6iAioqPxoPA3QKdadgKzB0QPqhblPQHviM/XjYUkEPN7ggwCYzRjDKacchhjTeBu4XAg26Vj2TILe7fvCSvS16+evO5VZwi0/Lq+nUd571uoh+uA9hUujSnc4t+ideyj0ZkH565W3y+RnGm8IkP953ibNyip2EHqHl5/d6lOYlbFPQr7yz5OEFfI7IPz9wtPrxCKVKNh39AwKo2APfv6S/dHW7BnkRNy4jG3mtKGHWLdsk2a7Xko/HmUbjFAgy4RVjhUGvRw6eD2dd4EN0ioDDZLU5GdIuAQnSLPid3C5UCJpxMRrcIiOgWfdxuYaaVp/WkewyeJzrpcgCinrpeiokjgKFMtvJI0LisnkZvpvbZVvTbvfUw1kvjJHS3MEweY7UZcws73ZmH6bCQW9igXClFK2Udvluj+AmaAR6HW8AIM5sLX7fQdUurYk+DZaIVlcW2jU0cWqIo631HOVgYSK85DiVOiEYOxRtaBx/XiNwndLdA7udePxhftzD265SzU9O1MWpg77E57OVIzs14YTgOaMs+bUNfM0DQboGs2xhDHMGYW2jyADWvPkT/sbyOhkojqzV1lOHH5ug4h05grDCqYtN+HaDOzVi/wUfjJGi3WJDlE7eKfCnCKYzoFgER3aIPuUUkELRMAiCU+76RoIhuEXEQ3SLiILpFxEF0i4iD6BYRB9EtIg6iW0QcRLeIOIhuEXEQ3SLSY7//PxFDuTUYUG8fAAAAAElFTkSuQmCC)

![Use of IN Operator in Sql Server](file:///C:\Users\MSCLIE~1\AppData\Local\Temp\msohtmlclip1\01\clip_image003.png)

---

Original Source: https://www.mindstick.com/articles/12620/use-of-in-operator-in-sql-server

Copyright © MindStick Software Pvt. Ltd. This Markdown version is provided for developers, AI systems, and offline reading.
