---
title: "How to Use Distinct Clause in Sql Server?"  
description: "How to Use Distinct Clause in Sql Server?"  
author: "Manish Kumar"  
published: 2017-05-03  
updated: 2020-09-18  
canonical: https://www.mindstick.com/interview/23234/how-to-use-distinct-clause-in-sql-server  
category: "database"  
tags: ["sql server"]  
reading_time: 1 minute  

---

# How to Use Distinct Clause in Sql Server?

Distinct clause is used to filter distinct values from the collection. It removes the Duplicate record from the list. Distinct clause use with the select statement.

```
Select Distinct ExpressionFrom
TableNameWhere
Condition;
```

Let us take an example to Understand this=>

```
CREATE TABLE [dbo].[Employee](          [Id] [int] IDENTITY(1,1) NOT NULL,          [Name] [varchar](50) NULL,          [Department] [varchar](50) NULL,)
```

And insert some record in it.

![How to Use Distinct Clause in Sql Server?](data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAAWMAAACjCAYAAABfXX/hAAAABGdBTUEAALGPC/xhBQAAAAlwSFlzAAAOwwAADsMBx2+oZAAAD9pJREFUeF7tnb2OHDcSgPedLponuBcxBvBTnOHQyaY6KFF0UKRMii45JUoOcKjAwCWGoQNsHOxQTvpYbLKbZLN/5qera4ffB5S32TPT2mV1fcPhrsmn7r//6AiCIIhjAxkTBEEYCGRMEARhIJ7evHnTEQRBEPXQ4umPP/7oNEN+uNp5giAIi6HFU/iqhuY7Dazzyy+/hCOwAPmwhWY+kHHjUPy2IB+2QMagBsVvC/JhC2QMalD8tiAftkDGoAbFbwvyYYvGZfyhOz+d3X9ryGOn7vmn0ISbWb/ZpM+fuqdzmRFysQeb85HEiSTsBjJGxmpsK/5Tdzo9dbmPycUebM3H2O/Srr1Z7oF2zo+/x5AxMlZjc/F/eHZCfu7GricXe3C5jB0/udzM1sw90c758fcYMk5vLH+jxY9jzwjgzlxS/B/O6UfivFDkseGj8zBKC88RkYfH5KGfnk/Dc7OP2Emun1TkYo+rZOzeIp/TTy7VfpzmIu37pfydz2O+8ufcI7/hGs/n4jVyPj7XxfA96YKMs0SNN1mf5PJGhFu4rPjnjlPK57hCiiPqD33BDQXq20VRxuu5x7JCboTbZTzXj0UuvBi35W/MQ/lvF9e8Kr/hGrHIl15zAMg4JkNuGD4a78rFxS/F4guncl6Kykc8X+ZroZ2NmkIcNBo6kutlvNaP09fJaHjo4lvz51lob/6+0nb5mD7IGBmrcXnxx1FYct4XWhzNJGKYvHahnV2jXa6Scdp3s/1Yvi4ZTd8jf56F9ubvK22Xj+mDjIekyTHTFHtyffEnIygZVVU//pavXWr3uW5xaiLl8nz0/TaMcGf7sTifyvEu+ROW2nI8930tvSZ9TB9knL6DJh+f+AXe/blKxo78jbEfZfk8nc7d+dqR1SD5EKNhmmFbPpI+quSm3o99X6e/jBu7d2v+3Jn4i77kmrP5LNsL39fca/J/T5/GZQyaaN5ssM5++SilB1tAxqAGMrYFMrYFMgY1kLEtyIctkDGoQfHbgnzYAhmDGhS/LciHLVRlLHIkCIIg6qEFI+PG+f3338MRWIB82EIzH8i4cSh+W5APWyBjUIPitwX5sEVTMv7L3+vx77P6t9YkFL8tyIctkLELZKwDxW8L8mELZOwCGetA8duCfNiiTRn/s2//DRmrMr3Z5H+bTRZzcXHQGi2O9v4X3no+aktPggbNyfjN/9zBf7ruX+4LMtalXvyJAP2qeUfJABnnMm6vP46mORnHQMb6rMr4UAEgY2R8LMgYGauxKuN04XHfTKYwhvmL8JqbNqZM1tR10V96et1HX3x+Xsbydeyfo9b3bQ1VGX/9+jUc6oCMbVEv/i1FH0Tp3RheE6UdNgQYxJlNdaSvk2bYmFKeM/m3ateN13lM5mUcj5O+g91RlfGvv/7a/fnnn6G5P8jYFvXiDwXvR7CF/IJo+0hlnEpioV3u9iDRD6P9+Xzku3bdxwMZ20JVxoyM22ZRxg6ZahgEmcn5yo0ra4JPiFMb2TTF7HUfD2RsC1UZh69qIGNbrMk4a8uoWGHj0fENYO26jwcytgUyRsZqrMs4jFa9hHfceDSb/piTz/R7ezSWZSzdlPQZ7E6zMk4DGeugebPBOuTDFsjYBTLWgeK3BfmwBTJ2gYx1oPhtQT5s0ZSM4VgofluQD1sgY1CD4rcF+bAFMgY1KH5bkA9bqMpYtqLWDJGx/IAEQRAvIbRgZNw4mjcbrEM+bIGMQQ2K3xbkwxbIGNSg+G1BPmyBjEENit8W5MMWyBjUoPhtQT5sgYxBDYrfFuTDFs3J+PPrv3bff9PHq/c/h7OgQfVmq66gthePvxLbJdxW/PTlvWlLxl/edh9/DMfdp+7dN992H7+EJuzO5GYrF3937eddbYxAUpCxLdqSccbP3cfvkLEmk5stXUBeBQSSgoxt0bCMZWT8Q/c5tGB/pjebFHRtJ46y0NN2f3w+y5ZJYVSdLSAfR9rsAL1GPR95//RbBtZ23i5z4h73nVzJD2yiWRnL3DFzxrrUb7ZRmuOGEmmhC9PCr0tBmuwAvZW5N8e8f5K+zvor9nufvzx3bb/JXUuDMpbpCUR8BIs3Wxjd9kVdCDZrF4+V2ypJyEXC+VwKS9dtj7qMl/onbffHJyfi5T6GrTQmY+aJj2TtZvMfh72N1yUwPOalOz+6bX0H6CVul7ET8SnmLNJ2n95CWzL+8Yfu+9efQgO0mdxsH56Tou0/7vajrOKjr/94nEqgFMTyx+KWd4Be4nYZ98eycenY/2336S00JePf3n87/I0xf2usT734i+mFSJiv7M+fqxIYKKcq5Drp6yfznL7haFsc95JxfPPs55rb7tNbaErGcCyaNxusQz5sgYxBDYrfFuTDFsgY1KD4bUE+bIGMQQ2K3xbkwxbIGNSg+G1BPmyBjEENit8W5MMWqjKu7eC8Z4iM5QckCIJ4CaEFI+PG0bzZYB3yYQtkDGpQ/LYgH7ZAxqAGxW8L8mELZAxqUPy2IB+2QMagBsVvC/JhC2QMalD8tiAftmhMxv3C8nHFtnfD5qSgwfRmkxW+4spqfWRLYfrV2O69AhirikUm+dilv2Erjcn4U/c5CvjL2+4Ve+CpUpdxWvxBztli5fcGGUeWi59+0qYxGaewIak26zJ2rOzccTtIJoKMbdGujNn1Q51NMs52+UgfD8fP46Lx0ymNON0RZR4WPQ/ns2uyQ/RCPuTr2G/7flKBSHMyHnb7QMTq3C7jRAzVnYp9wz/mBSvPmYgkXIcdolfyUfQp7E5zMh6QkfE3bE6qyXYZ14RQPjdpl9suRWmH8/nId+E6jYGMbdGujB2fX/MXFZpsknE2Z7wkh6S9Ms/MDtF1kLEt2pLxj5+SX9jJL/AYGWuyLmNpJ7tCL8qhfGx57pcdoqcgY1u0JWP/52z8nfFR1Is/nV4oi39JDkW7nKoQo7ND9CJrb46yBf/Ql7A7bckYDkXzZoN1yIctkDGoQfHbgnzYAhmDGhS/LciHLZAxqEHx24J82AIZgxoUvy3Ihy2QMahB8duCfNhCVca1HZz3DJGx/IAEQRAvIbRgZNw4mjcbrEM+bIGMQQ2K3xbkwxbIGNSg+G1BPmyBjEENit8W5MMWyBjUoPhtQT5sgYxBDYrfFuTDFm3K2C8sX+x/58/1q7m9ev9zOOmYOS9rIVefD7Ms3Wx+hbBbVgfzq7a1ufratUzyQR8eSmMyDlv1v/6h2Iw03Zw0Xed45vyXt93HYflN1kXeyuzNJhI4nbvzsMPHrbS7LOYlLBc/fahNYzKOpJJ1FJuTyj55frQ7dz5DBI+MtzB3s8WF38cF4G8FkWwBGdsCGTsmkg0SnjufU4gdZqnfbMmed36EHDYK9QQhJDs5y0xG3EZJYpR3lId8DYuiS7Aw+izTfNCHR4KMHbfIWOaOp6NlqFG92TIBp5uRCkEK2U7OiYCznZ2jSMpjmGNexuUxaICMHdfJuJ9/RsTbqd1s5dSEH/UOI7FSCEttRHIpyNgWyFgoRryDhOfOM098FfXiTz4OD7F1v7o5eZTPgxrI2BbIWPAblca2PDb+1UT1fGW6AtaZ3GwyzZDNEQsyVbF1W/05eSCSLSBjWyDjiAg2/N1wtmt05byMkOO5GExXrFPebPK3xbW/nhinKkohLLXzx9jZeJ1lGdOH2jQqYzgCzZsN1iEftkDGoAbFbwvyYQtkDGpQ/LYgH7ZAxqAGxW8L8mELZAxqUPy2IB+2QMagBsVvC/JhC1UZ13Zw3jNExvIDEgRBvITQgpFx42jebLAO+bAFMgY1KH5bkA9bIGNQg+K3BfmwBTIGNSh+W5APWyBjUIPitwX5sAUyBjUofluQD1u0KWO/Etv8qm2TBeUn58PGpuF8tsobzDK92WSVsLAyWIjjFggrV4R7fGbzMZOEfrur+ip5cDuNyfhOu0O7489RwNmax7BEvfiTgs62UdIGGcc+OFV36Q6iRsa70ZiMI8V6xjL6vWinj5TiWjDLqowPLfD25DKXj/O5sku3vFGez0kfIeN7g4wdE8kGCc+dz6idgyqrMi52/hgWN88+OofXbNox2iEbnobz46i7300kPr+/9PS6tYXvH4n5fMjX9BNK3Cg2zVd57PrMd2R/XoR+3KeclwkydlwjY3nMzxkj4s3Ui3+U4vyOEpXCv3jHaGme++f5UV75b9Wu+9gyWXpzlDfCoYuGHbzLPMhxuk2W0Pfjo7+R7QEydtw8Mh7mkmGJpeLvR7CF/IJo+ygl4J/hWGhno+IQYo1wPhfG2nUfj9V8hDemUcxpn/THJyfi5X6ErSBjoZDsIOG58wWfX/MXFVtYLH5Htm1/Juf4MVmOy2JfaNcEnxCnNqaiEcr247Gcj9DnMm0zTB2lj8uxE7F7Tv4p4/H7bS+QsXDx7tCfxtem52GRNRlnbRkVRwl4qaYSmHmNJ23L8fJH5vENYO26j8dqPsInk7H/yr7tj2XkXH8OXAIyjvjphsrfDdfOe0n35ybPh1nWZRxGq17CyS/ZTufufM3IWAhTEtk0RTb9MTO/PGk/Huv5kByknyzSx9PjkKvJvDJcQqMyhiPQvNlgHfJhC2QMalD8tiAftkDGoAbFbwvyYQtkDGpQ/LYgH7ZAxqAGxW8L8mELZAxqUPy2IB+2UJVxbQfnPUNkLD8gQRDESwgtGBk3jubNBuuQD1sgY1CD4rcF+bAFMgY1KH5bkA9bIGNQg+K3BfmwBTIGNSh+W5APWyBjUIPitwX5sEWbMvYrsc2v2jZZUL52PuB3/PjubfdbaMM805tNVviKq6f1kS2Nq0p7q43V89Gv0pZteZXE0nKkcBuNyfheu0NH5Jy7HjLeRL34EwEeutURMk5lPNJevxxFYzKOpJJ1yOj3ip0+pP3u/dvuFTLexKqMDy18ZIyMjwUZOybbKQUJz533yALzcixfkfEmVmWc7u7hm8lH5GH+IryG3aFvBhnbAhk7LpexTHckWzMh403Ui3+U4nTH5kgqhPCaKO1ya6BsqqMQiXvMP0+eM/m3atctxfRYIGNbIGPHpTLOziPjzdSLPxR6bfPQINo+Uhmnclhol1suSfTDaH8+H/muXffxQMa2QMZCOv3gGGRbPf/Wvbb/64osEPIqizJ2sDu0LsjYFshY8BuMxrY8lkxB1M6nMDLezJqMs7aMiuOUgZdqfN7CazxpW46X537ZHTpFfmZkfBTIOCKj4DDKXd0dOgUZb2ZdxmG06iXM7tB7g4xt0aiM4Qg0bzZYh3zYAhmDGhS/LciHLZAxqEHx24J82AIZgxoUvy3Ihy2QMahB8duCfNgCGYMaFL8tyIctVGVc28F5zxAZyw9IEATxEkILRsaNo3mzwTrkwxbIGNSg+G1BPmyBjEENit8W5MMWyBjUoPhtQT5sgYxBDYrfFuTDFsgY1KD4bUE+bKGXj677PxhoOEoy4015AAAAAElFTkSuQmCC)\

\

```
Select Distinct Name from
Test.dbo.Employee 
```

\

\

![How to Use Distinct Clause in Sql Server?](data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAAOYAAAChCAYAAADTN8NvAAAABGdBTUEAALGPC/xhBQAAAAlwSFlzAAAOwwAADsMBx2+oZAAAD4RJREFUeF7tnU1vJNUVhut/5Bdkl2AbyV5kk4QkPyDL0XiCU4H8iUhIOGxGYykSkncsIiTkyYZovGaJgmV2fNiAhBBSgBkYsmLlm3vuvefWqdO3uquqb3109/uIl66+XVU9btXjc0+5q7v4+eEfzcEf/hpD97/66iujubt5aPb3H5qbuztzd/fEnBQn5oldrj/WNO7vM3dPTkxx8sQtPzkpzP7Dm8Z1h4Z+1ufPny/kxx9/dHn27Jn55JNPzO3tbRzX6yJI7hRSSk5nMeP9pnEl5t2NebhfmKKg+MdJ0JMn+aX829//YX7281/VQmPMMjG///57c3Nz46T84Ycfoqyp9REkZ6KYsnIOLaamXnHrwuZAyimlJJaJ+dlnn5mPPvrIVU2WEmIiYyRPxayJlRpvFsxXz33z8MbuV01xc1ZQElJLSSwT8+nTp24a+8UXX8QxiImMkV49JiHFuXm4nxRKjjchZRxSzCaWiUn57rvvXNUkOSEmMlZaVUwnWJxiemF81VycdjaNp5DV0t8X266otLlYJSblm2++cXJ++eWXEBMZJa17zG2ljZg6qfURJGda95jbSpOYCDJlGnvMXUrqhUGQKdNYMXcpqRcGQaZMY4+5S0m9MAgyZZIVM7UigiDjJdljplZEEGS8oGIiyAyT7DFTKyIIMl6SFfPTTz9FViT1YiJIriR7TDrwQDMQExk6jRUTNMNVE+me1EGILCbZY9ILCJrBAdYveN3ap3fFLM+vlmavTGcbaDrA3nvvPZd33313IW+99c/kNrsUiNk+vXtMks/+V+WcxpZn28U8pxciwbfffmt//vPkNrsUiNk+2SumrpC17K0Q8/aROYzXclYpL8Pj60L7P3xkbsPdvrQRky4Pu3pqXN7+z3NT2t9MqW12KRCzfXr3mLo6fPDBB2HJQ1M65qeffnLr7+2VYaSBlDiZZHLwvtbc5yoxP/74Y3N1deVeE5KSxiEmxOyS3hVTiylFJKivIkhKqh60/uHhoRtrJCnMpSmL0v4/AyOIeW6FpJ+dlqmv5PQW8/rUHNDM4fhCjF+b0wM7dnBqruW6Mw/EbJ/ePSYdbFQZqCrwSQ8ZPjj5xEdvMeUYLccp7qF5FFa8fXQYp72HNKj3w/fdbWnKw7CPsM7C9itYJmYKqpqxelpxKZ9//nlyHwshMQ8ObISELCvE3Nr0rpgkm4RklNBByh/FQX0Wrd9KzCBIFa6Wt+aR3T56E+UTFdVtb5fjYwG+r2/dg4nt3Xgzy8Sky8joZA/F+udkpEhoPZrWt5LTiXlqTo8PzOl1GLs4NgfHNhBza5Otx5Ri0vSVKqU8AdJaTCmUkzGc/HHSaGlJVL8O3Y/VTu+H7+tb/+Di9itYJibJtjBzIEMJOnV9Xrr1qIK2kjOIeU0ynl67sQuS9CKM8zrxNakEvj49CGNF3DY1dnHM2/ocX4jnFuOxQnd4PhmI2T69K+abb77pTnDwASh7K76lkJB+KntuZegxlb0sTUFm0mMrqtllSQdF14pZEbcP95tYJmaKKGaAZNwrSycmJbWvGBaTb59fmOPafeo3RTWV6xXH5oLH3HJqLGzHqe1XSdr5+cI6IRCzfXr3mCSmhA5KPtFDIRldtQzTOVq/11nZONUU1ZOgdVnC2G/ydFedMCK5m8RMbk/LzawSk2cKbjprb6uKaX9+KyRRnu+59UnQ1L5iakLYg91WTnciiMedBFy9OCROOEFUq16psfAccnver3te9e/o9Hz1QMz2WatiSnjqygelEzNIuZ6YUkgSjg+GSqDUyRs5VljZ6kLyfry8uU/+0GvAUjoxVSWlx6lqkrCtK6ZdpqkinQhyVawmSqLyifipan2daowqXaICiuddGO/xfBSI2T69e0wSLfZQ9sDj8NTVT1+v3HqclWJuCKvElFLSLyced9Wy3HMniFzF7CimW+YDPo77SlXvC+067paFo3XsMvWleuxaTEEpVJGb9tv1+Vj2EIjZPmtVTOoZ6cBK3eplzjbQWkx7t7zac7+kGHqM/szk+nK7ficxG8dJLl/x+5z8kWMuvF8nW2K8w/PJQMz2wfWYPVgmJp1tpVuqhpwopq2WFHdG1t62EnMu4d429VjLQMz26V0xd5llYtLJnPv37/uzriEsJvXaTlYS14bG5yumrIr1ytg3ELN9eveYu0zXA4wFbEpqm20MxGwfVMwe4ADrF7xu7YMeswf0+iDIkEHFBGCGtOoxL/71bwRBRkyrikkrTsnXX38dlraXXfgZQXta9ZgQc3ggJpCgYs4EiAkkrXvMKYGYYNfY7Ip5e2aOiiNzJi8IobGjM3WFyvyBmECy2T2mE7MwhRQRYoItYPMrppXwrJQXUENMsPlsdo/JEkoZxbL/qJAq/rOD6PHSlEd+7Ojs0pzF5aAzrRO3U1PlgYCYQLIVFZMlrMRLVEwed9IF2fSy2+7WiipkbNpfZiAmkGx+jxmlubRVMIjHY048rnw2qcf1st7GZfiqCTGBZGsqpr97ZI7KMozR5/okKl9KRv14i0/Kyw3EBJLt6DHD3fhhXW6MltUn5bF4WsbaMk1l1cmkEUSFmECyVRWToKrJfz5xy3JKSuMrxST4U/Qow09jCYgJJHiv7EyAmECy2RVzi4CYQGLFfNXK+GroMf0yxBwfiAkkUUxfLSHmVEBMIPE95u+tkCHoMacBYgKJ7zGFmE09ZuqTvMYMnSHd5lsAJIWslLzcJOZU0HP/99n/tjYkJwCSYt+KSKFKyctzFJMO3tRBvQ1BxQQa12OykJSmHhMVc7igYgKN6zGlmMt6zKlAxQS7RpzKysrZT0z13tSMtK6Y7zywAr9oXrtKPDbjoGICTYYe07/pmw4u/obm3LStmG/fL8y9+w/M/usfJh9fyNUbZv/gDfM+36bWGSGomECTscecumJ+aF47eGDefvbY3Osq2cRiomICTcYec1gxV1ZMkuv+Y7tMgobprBPugRXVV/T91x/bx3jZVlX1eDGRnKiYQLM1Peb7r79o7r1TLUfxuOfUy3IKy7dqn2MFFRNorJivWBlfCT2mX968iklVMlQ9jhYutTwTMVExgSb0mF5Iykb2mCSWm8byWJjOvpOQUS7PRExUTKAJPWYl5ib2mHHqqsfoDO0GiImKCTRxKisr52ZVzMfmXupvlyQbT2n5fpOYbh80BaazumIfIwUVE2gy9pjDsapibnpQMYEmY485HMsr5uYHFRNoMvaYw4GKCXaNYv93VkgbVznDMirmuEHFBJoopqucMxYTFRPsEr7HDEJSlvWYU4fk3NZbACS+xxRizrXH3Ga2/ecD3dmYHnObgZhAszE95jYDMYGmU485FRAT7Bqhx/xLTJ8es/aV6vH76/Kx8sB1X5Un/g02A/wz1DeC5QNiAk2xZ2WkUKXk5S5iuq+6q75Msv7dkploJWZNGPHvyCkTxAQjEcWkStlHTI37VufMXyjZXUzLEBJBTDASrsdkISnr9ZhzqZhEuNqFHwu3Z2LaXRV6+1icBldfVCu/+Nb9slm2jzWAmEDjekwpZp8ek5Hf5pyTfmLSLwkr2aUQU4oUtwnr8cZxXFzG5rYNkif3sR4QE2jW7jGZoaQk+omZrphxHTkeql8VEtVXf7ofp+ZN+wh3+wIxgSZLjzmklEQvMaV48jY8XHt8xQXe/qyzkDyMQ0wwFOv3mJelP2jD3SHoLmbirGyjVKovpvE4beUprpoWuxUtep89gZhAs3aPWfsbZsgkZ2XVv2GhD9QS1e7TtJe3rfrNppM/6X30B2ICTbYec0i2/cCFmEBT7L1kZbRxlTMsQ8xxgZhA43vMICSlc485AhAT7Bq+xxRidu0xxwBigl3DTmVLK2Tpe8ywDDHHBWICTRTTV87lYiLDBQBJ6DG9kBT0mOMDMYEm9JiVmOgxxwdiAg16zBkAMYGmU485FRAT7BpZekz5trz4VriMrDxw6a1x4fllhvi3JFnzrXkQE2jW7zHpTey195zmf0N7KzG1GJnex9oKiAkyk7nHVBcdZ6KXmAP9kkgCMUFm8vaYdIDOsGLqK2Cqy8FKU8aLoS/TF0bH7VZfddL3I0cgJtBk+zsmH6zz6TEbfkGwsG6bIJtedkKr6h/H83/kCMQEGtdjvmCF5HTuMWuoi44z0UrMmgipi5+FtCwmb5Na1tu4kKh+33Q/10eOQEygKVhIqpS83F9MOiZn8vGVdFLKmUkVLlH55DapZbpdMS3P9ZEjEBNoopiycnYR001hq9I0k4pJ8JRTnQTis8hym+RyqurytJVFp3Xs8pofOQIxgcb1mC+89OeYPj2mPLmSu1oS/cSsxJIna1xoXblN07KTmrerqm7TyZ/w8OL9FUBMoPE95m+tlCHr9ZjDsO0HLsQEmoKFdJUzLEPMcYGYQBPFlJUTYo4LxAQa32MGISl9esyhgZhg10CPOQMgJtB06jGR4QKABD3mDICYQIMecwZATKBBjzkDICbQ4O+YMwBiAk3WHpPemjfJW/IIehtcfPtc/vfrOjq+1a4tEBNo8vWYQYxpxExcQbLiypBeQEwwEqHHPInp12P6qyzKMv8lX0SrXwoDCLMAxAQjYaeyXkhfOf1yZzHDtY9DXItJrD5w/ZUkC8+tReL77pY/VoQv5eJp8OqrSPp+hEgTEBNoopiycnYTs7recToxCS9nTa5lYuprKnmluI24jtOtXwlcu0ZT7r8nEBNoQo/phaR07TGljNOKKUhdDE3wfTkeZOMKWIldiR5/pqb9hbt9gZhAs2aPKatUldxydj9wQ7VrEkmO0zJXxgZyfYRIExATaIoXfmOFtHGVMyx3P/njmapiul5QNnvxQ6jFdJRIVlL/y6U2PY3TVjXdXfMjRJqAmEATxXSVc0PFJOqfHVvJ6KTlcSuXE2lBKBKYt636Tbmt+7n0dhATDITvMYOQlK495hhs+4ELMYHG9Zi/tEJyuvWY4wAxwa5RsJBUKXkZYo4LxASaKKasnBBzXCAm0Lgek4WkoMccH4gJNJ16TGSYAKCxU9mXrZAvhx7TL6fEBACMRxTTV06ICcAcCD2mF5LS1GMCAMYj9JiVmE09JgBgPNBjAjBD0GMCMEPQYwIwQ9BjAjBD0GMCMEPQYwIwQ3yP+WsrZAh6TACmx/eYQkz0mABMTyErJS9DTACmJYopKyfEBGBaQo/5pxj0mABMT+gxKzHRYwIwPXYqW1VKXoaYAExLFFNWTogJwLS4HvMXVkYOekwApsf1mFJM9JgATE8hKyUvQ0wApiWKKSsnxARgWtBjAjBD0GMCMEPQYwIwQ9BjAjBD0GMCMDuM+T82P0/sjOKI1gAAAABJRU5ErkJggg==)\

\

\

## Answers

### Answer by Manish Kumar

Distinct clause is used to filter distinct values from the collection. It removes the Duplicate record from the list. Distinct clause use with the select statement.

```
Select Distinct ExpressionFrom
TableNameWhere
Condition;
```

Let us take an example to Understand this=>

```
CREATE TABLE [dbo].[Employee](          [Id] [int] IDENTITY(1,1) NOT NULL,          [Name] [varchar](50) NULL,          [Department] [varchar](50) NULL,)
```

And insert some record in it.

![How to Use Distinct Clause in Sql Server?](data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAAWMAAACjCAYAAABfXX/hAAAABGdBTUEAALGPC/xhBQAAAAlwSFlzAAAOwwAADsMBx2+oZAAAD9pJREFUeF7tnb2OHDcSgPedLponuBcxBvBTnOHQyaY6KFF0UKRMii45JUoOcKjAwCWGoQNsHOxQTvpYbLKbZLN/5qera4ffB5S32TPT2mV1fcPhrsmn7r//6AiCIIhjAxkTBEEYCGRMEARhIJ7evHnTEQRBEPXQ4umPP/7oNEN+uNp5giAIi6HFU/iqhuY7Dazzyy+/hCOwAPmwhWY+kHHjUPy2IB+2QMagBsVvC/JhC2QMalD8tiAftkDGoAbFbwvyYYvGZfyhOz+d3X9ryGOn7vmn0ISbWb/ZpM+fuqdzmRFysQeb85HEiSTsBjJGxmpsK/5Tdzo9dbmPycUebM3H2O/Srr1Z7oF2zo+/x5AxMlZjc/F/eHZCfu7GricXe3C5jB0/udzM1sw90c758fcYMk5vLH+jxY9jzwjgzlxS/B/O6UfivFDkseGj8zBKC88RkYfH5KGfnk/Dc7OP2Emun1TkYo+rZOzeIp/TTy7VfpzmIu37pfydz2O+8ufcI7/hGs/n4jVyPj7XxfA96YKMs0SNN1mf5PJGhFu4rPjnjlPK57hCiiPqD33BDQXq20VRxuu5x7JCboTbZTzXj0UuvBi35W/MQ/lvF9e8Kr/hGrHIl15zAMg4JkNuGD4a78rFxS/F4guncl6Kykc8X+ZroZ2NmkIcNBo6kutlvNaP09fJaHjo4lvz51lob/6+0nb5mD7IGBmrcXnxx1FYct4XWhzNJGKYvHahnV2jXa6Scdp3s/1Yvi4ZTd8jf56F9ubvK22Xj+mDjIekyTHTFHtyffEnIygZVVU//pavXWr3uW5xaiLl8nz0/TaMcGf7sTifyvEu+ROW2nI8930tvSZ9TB9knL6DJh+f+AXe/blKxo78jbEfZfk8nc7d+dqR1SD5EKNhmmFbPpI+quSm3o99X6e/jBu7d2v+3Jn4i77kmrP5LNsL39fca/J/T5/GZQyaaN5ssM5++SilB1tAxqAGMrYFMrYFMgY1kLEtyIctkDGoQfHbgnzYAhmDGhS/LciHLVRlLHIkCIIg6qEFI+PG+f3338MRWIB82EIzH8i4cSh+W5APWyBjUIPitwX5sEVTMv7L3+vx77P6t9YkFL8tyIctkLELZKwDxW8L8mELZOwCGetA8duCfNiiTRn/s2//DRmrMr3Z5H+bTRZzcXHQGi2O9v4X3no+aktPggbNyfjN/9zBf7ruX+4LMtalXvyJAP2qeUfJABnnMm6vP46mORnHQMb6rMr4UAEgY2R8LMgYGauxKuN04XHfTKYwhvmL8JqbNqZM1tR10V96et1HX3x+Xsbydeyfo9b3bQ1VGX/9+jUc6oCMbVEv/i1FH0Tp3RheE6UdNgQYxJlNdaSvk2bYmFKeM/m3ateN13lM5mUcj5O+g91RlfGvv/7a/fnnn6G5P8jYFvXiDwXvR7CF/IJo+0hlnEpioV3u9iDRD6P9+Xzku3bdxwMZ20JVxoyM22ZRxg6ZahgEmcn5yo0ra4JPiFMb2TTF7HUfD2RsC1UZh69qIGNbrMk4a8uoWGHj0fENYO26jwcytgUyRsZqrMs4jFa9hHfceDSb/piTz/R7ezSWZSzdlPQZ7E6zMk4DGeugebPBOuTDFsjYBTLWgeK3BfmwBTJ2gYx1oPhtQT5s0ZSM4VgofluQD1sgY1CD4rcF+bAFMgY1KH5bkA9bqMpYtqLWDJGx/IAEQRAvIbRgZNw4mjcbrEM+bIGMQQ2K3xbkwxbIGNSg+G1BPmyBjEENit8W5MMWyBjUoPhtQT5sgYxBDYrfFuTDFs3J+PPrv3bff9PHq/c/h7OgQfVmq66gthePvxLbJdxW/PTlvWlLxl/edh9/DMfdp+7dN992H7+EJuzO5GYrF3937eddbYxAUpCxLdqSccbP3cfvkLEmk5stXUBeBQSSgoxt0bCMZWT8Q/c5tGB/pjebFHRtJ46y0NN2f3w+y5ZJYVSdLSAfR9rsAL1GPR95//RbBtZ23i5z4h73nVzJD2yiWRnL3DFzxrrUb7ZRmuOGEmmhC9PCr0tBmuwAvZW5N8e8f5K+zvor9nufvzx3bb/JXUuDMpbpCUR8BIs3Wxjd9kVdCDZrF4+V2ypJyEXC+VwKS9dtj7qMl/onbffHJyfi5T6GrTQmY+aJj2TtZvMfh72N1yUwPOalOz+6bX0H6CVul7ET8SnmLNJ2n95CWzL+8Yfu+9efQgO0mdxsH56Tou0/7vajrOKjr/94nEqgFMTyx+KWd4Be4nYZ98eycenY/2336S00JePf3n87/I0xf2usT734i+mFSJiv7M+fqxIYKKcq5Drp6yfznL7haFsc95JxfPPs55rb7tNbaErGcCyaNxusQz5sgYxBDYrfFuTDFsgY1KD4bUE+bIGMQQ2K3xbkwxbIGNSg+G1BPmyBjEENit8W5MMWqjKu7eC8Z4iM5QckCIJ4CaEFI+PG0bzZYB3yYQtkDGpQ/LYgH7ZAxqAGxW8L8mELZAxqUPy2IB+2QMagBsVvC/JhC2QMalD8tiAftmhMxv3C8nHFtnfD5qSgwfRmkxW+4spqfWRLYfrV2O69AhirikUm+dilv2Erjcn4U/c5CvjL2+4Ve+CpUpdxWvxBztli5fcGGUeWi59+0qYxGaewIak26zJ2rOzccTtIJoKMbdGujNn1Q51NMs52+UgfD8fP46Lx0ymNON0RZR4WPQ/ns2uyQ/RCPuTr2G/7flKBSHMyHnb7QMTq3C7jRAzVnYp9wz/mBSvPmYgkXIcdolfyUfQp7E5zMh6QkfE3bE6qyXYZ14RQPjdpl9suRWmH8/nId+E6jYGMbdGujB2fX/MXFZpsknE2Z7wkh6S9Ms/MDtF1kLEt2pLxj5+SX9jJL/AYGWuyLmNpJ7tCL8qhfGx57pcdoqcgY1u0JWP/52z8nfFR1Is/nV4oi39JDkW7nKoQo7ND9CJrb46yBf/Ql7A7bckYDkXzZoN1yIctkDGoQfHbgnzYAhmDGhS/LciHLZAxqEHx24J82AIZgxoUvy3Ihy2QMahB8duCfNhCVca1HZz3DJGx/IAEQRAvIbRgZNw4mjcbrEM+bIGMQQ2K3xbkwxbIGNSg+G1BPmyBjEENit8W5MMWyBjUoPhtQT5sgYxBDYrfFuTDFm3K2C8sX+x/58/1q7m9ev9zOOmYOS9rIVefD7Ms3Wx+hbBbVgfzq7a1ufratUzyQR8eSmMyDlv1v/6h2Iw03Zw0Xed45vyXt93HYflN1kXeyuzNJhI4nbvzsMPHrbS7LOYlLBc/fahNYzKOpJJ1FJuTyj55frQ7dz5DBI+MtzB3s8WF38cF4G8FkWwBGdsCGTsmkg0SnjufU4gdZqnfbMmed36EHDYK9QQhJDs5y0xG3EZJYpR3lId8DYuiS7Aw+izTfNCHR4KMHbfIWOaOp6NlqFG92TIBp5uRCkEK2U7OiYCznZ2jSMpjmGNexuUxaICMHdfJuJ9/RsTbqd1s5dSEH/UOI7FSCEttRHIpyNgWyFgoRryDhOfOM098FfXiTz4OD7F1v7o5eZTPgxrI2BbIWPAblca2PDb+1UT1fGW6AtaZ3GwyzZDNEQsyVbF1W/05eSCSLSBjWyDjiAg2/N1wtmt05byMkOO5GExXrFPebPK3xbW/nhinKkohLLXzx9jZeJ1lGdOH2jQqYzgCzZsN1iEftkDGoAbFbwvyYQtkDGpQ/LYgH7ZAxqAGxW8L8mELZAxqUPy2IB+2QMagBsVvC/JhC1UZ13Zw3jNExvIDEgRBvITQgpFx42jebLAO+bAFMgY1KH5bkA9bIGNQg+K3BfmwBTIGNSh+W5APWyBjUIPitwX5sAUyBjUofluQD1u0KWO/Etv8qm2TBeUn58PGpuF8tsobzDK92WSVsLAyWIjjFggrV4R7fGbzMZOEfrur+ip5cDuNyfhOu0O7489RwNmax7BEvfiTgs62UdIGGcc+OFV36Q6iRsa70ZiMI8V6xjL6vWinj5TiWjDLqowPLfD25DKXj/O5sku3vFGez0kfIeN7g4wdE8kGCc+dz6idgyqrMi52/hgWN88+OofXbNox2iEbnobz46i7300kPr+/9PS6tYXvH4n5fMjX9BNK3Cg2zVd57PrMd2R/XoR+3KeclwkydlwjY3nMzxkj4s3Ui3+U4vyOEpXCv3jHaGme++f5UV75b9Wu+9gyWXpzlDfCoYuGHbzLPMhxuk2W0Pfjo7+R7QEydtw8Mh7mkmGJpeLvR7CF/IJo+ygl4J/hWGhno+IQYo1wPhfG2nUfj9V8hDemUcxpn/THJyfi5X6ErSBjoZDsIOG58wWfX/MXFVtYLH5Htm1/Juf4MVmOy2JfaNcEnxCnNqaiEcr247Gcj9DnMm0zTB2lj8uxE7F7Tv4p4/H7bS+QsXDx7tCfxtem52GRNRlnbRkVRwl4qaYSmHmNJ23L8fJH5vENYO26j8dqPsInk7H/yr7tj2XkXH8OXAIyjvjphsrfDdfOe0n35ybPh1nWZRxGq17CyS/ZTufufM3IWAhTEtk0RTb9MTO/PGk/Huv5kByknyzSx9PjkKvJvDJcQqMyhiPQvNlgHfJhC2QMalD8tiAftkDGoAbFbwvyYQtkDGpQ/LYgH7ZAxqAGxW8L8mELZAxqUPy2IB+2UJVxbQfnPUNkLD8gQRDESwgtGBk3jubNBuuQD1sgY1CD4rcF+bAFMgY1KH5bkA9bIGNQg+K3BfmwBTIGNSh+W5APWyBjUIPitwX5sEWbMvYrsc2v2jZZUL52PuB3/PjubfdbaMM805tNVviKq6f1kS2Nq0p7q43V89Gv0pZteZXE0nKkcBuNyfheu0NH5Jy7HjLeRL34EwEeutURMk5lPNJevxxFYzKOpJJ1yOj3ip0+pP3u/dvuFTLexKqMDy18ZIyMjwUZOybbKQUJz533yALzcixfkfEmVmWc7u7hm8lH5GH+IryG3aFvBhnbAhk7LpexTHckWzMh403Ui3+U4nTH5kgqhPCaKO1ya6BsqqMQiXvMP0+eM/m3atctxfRYIGNbIGPHpTLOziPjzdSLPxR6bfPQINo+Uhmnclhol1suSfTDaH8+H/muXffxQMa2QMZCOv3gGGRbPf/Wvbb/64osEPIqizJ2sDu0LsjYFshY8BuMxrY8lkxB1M6nMDLezJqMs7aMiuOUgZdqfN7CazxpW46X537ZHTpFfmZkfBTIOCKj4DDKXd0dOgUZb2ZdxmG06iXM7tB7g4xt0aiM4Qg0bzZYh3zYAhmDGhS/LciHLZAxqEHx24J82AIZgxoUvy3Ihy2QMahB8duCfNgCGYMaFL8tyIctVGVc28F5zxAZyw9IEATxEkILRsaNo3mzwTrkwxbIGNSg+G1BPmyBjEENit8W5MMWyBjUoPhtQT5sgYxBDYrfFuTDFsgY1KD4bUE+bKGXj677PxhoOEoy4015AAAAAElFTkSuQmCC)\

\

```
Select Distinct Name from
Test.dbo.Employee 
```

\

\

![How to Use Distinct Clause in Sql Server?](data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAAOYAAAChCAYAAADTN8NvAAAABGdBTUEAALGPC/xhBQAAAAlwSFlzAAAOwwAADsMBx2+oZAAAD4RJREFUeF7tnU1vJNUVhut/5Bdkl2AbyV5kk4QkPyDL0XiCU4H8iUhIOGxGYykSkncsIiTkyYZovGaJgmV2fNiAhBBSgBkYsmLlm3vuvefWqdO3uquqb3109/uIl66+XVU9btXjc0+5q7v4+eEfzcEf/hpD97/66iujubt5aPb3H5qbuztzd/fEnBQn5oldrj/WNO7vM3dPTkxx8sQtPzkpzP7Dm8Z1h4Z+1ufPny/kxx9/dHn27Jn55JNPzO3tbRzX6yJI7hRSSk5nMeP9pnEl5t2NebhfmKKg+MdJ0JMn+aX829//YX7281/VQmPMMjG///57c3Nz46T84Ycfoqyp9REkZ6KYsnIOLaamXnHrwuZAyimlJJaJ+dlnn5mPPvrIVU2WEmIiYyRPxayJlRpvFsxXz33z8MbuV01xc1ZQElJLSSwT8+nTp24a+8UXX8QxiImMkV49JiHFuXm4nxRKjjchZRxSzCaWiUn57rvvXNUkOSEmMlZaVUwnWJxiemF81VycdjaNp5DV0t8X266otLlYJSblm2++cXJ++eWXEBMZJa17zG2ljZg6qfURJGda95jbSpOYCDJlGnvMXUrqhUGQKdNYMXcpqRcGQaZMY4+5S0m9MAgyZZIVM7UigiDjJdljplZEEGS8oGIiyAyT7DFTKyIIMl6SFfPTTz9FViT1YiJIriR7TDrwQDMQExk6jRUTNMNVE+me1EGILCbZY9ILCJrBAdYveN3ap3fFLM+vlmavTGcbaDrA3nvvPZd33313IW+99c/kNrsUiNk+vXtMks/+V+WcxpZn28U8pxciwbfffmt//vPkNrsUiNk+2SumrpC17K0Q8/aROYzXclYpL8Pj60L7P3xkbsPdvrQRky4Pu3pqXN7+z3NT2t9MqW12KRCzfXr3mLo6fPDBB2HJQ1M65qeffnLr7+2VYaSBlDiZZHLwvtbc5yoxP/74Y3N1deVeE5KSxiEmxOyS3hVTiylFJKivIkhKqh60/uHhoRtrJCnMpSmL0v4/AyOIeW6FpJ+dlqmv5PQW8/rUHNDM4fhCjF+b0wM7dnBqruW6Mw/EbJ/ePSYdbFQZqCrwSQ8ZPjj5xEdvMeUYLccp7qF5FFa8fXQYp72HNKj3w/fdbWnKw7CPsM7C9itYJmYKqpqxelpxKZ9//nlyHwshMQ8ObISELCvE3Nr0rpgkm4RklNBByh/FQX0Wrd9KzCBIFa6Wt+aR3T56E+UTFdVtb5fjYwG+r2/dg4nt3Xgzy8Sky8joZA/F+udkpEhoPZrWt5LTiXlqTo8PzOl1GLs4NgfHNhBza5Otx5Ri0vSVKqU8AdJaTCmUkzGc/HHSaGlJVL8O3Y/VTu+H7+tb/+Di9itYJibJtjBzIEMJOnV9Xrr1qIK2kjOIeU0ynl67sQuS9CKM8zrxNakEvj49CGNF3DY1dnHM2/ocX4jnFuOxQnd4PhmI2T69K+abb77pTnDwASh7K76lkJB+KntuZegxlb0sTUFm0mMrqtllSQdF14pZEbcP95tYJmaKKGaAZNwrSycmJbWvGBaTb59fmOPafeo3RTWV6xXH5oLH3HJqLGzHqe1XSdr5+cI6IRCzfXr3mCSmhA5KPtFDIRldtQzTOVq/11nZONUU1ZOgdVnC2G/ydFedMCK5m8RMbk/LzawSk2cKbjprb6uKaX9+KyRRnu+59UnQ1L5iakLYg91WTnciiMedBFy9OCROOEFUq16psfAccnver3te9e/o9Hz1QMz2WatiSnjqygelEzNIuZ6YUkgSjg+GSqDUyRs5VljZ6kLyfry8uU/+0GvAUjoxVSWlx6lqkrCtK6ZdpqkinQhyVawmSqLyifipan2daowqXaICiuddGO/xfBSI2T69e0wSLfZQ9sDj8NTVT1+v3HqclWJuCKvElFLSLyced9Wy3HMniFzF7CimW+YDPo77SlXvC+067paFo3XsMvWleuxaTEEpVJGb9tv1+Vj2EIjZPmtVTOoZ6cBK3eplzjbQWkx7t7zac7+kGHqM/szk+nK7ficxG8dJLl/x+5z8kWMuvF8nW2K8w/PJQMz2wfWYPVgmJp1tpVuqhpwopq2WFHdG1t62EnMu4d429VjLQMz26V0xd5llYtLJnPv37/uzriEsJvXaTlYS14bG5yumrIr1ytg3ELN9eveYu0zXA4wFbEpqm20MxGwfVMwe4ADrF7xu7YMeswf0+iDIkEHFBGCGtOoxL/71bwRBRkyrikkrTsnXX38dlraXXfgZQXta9ZgQc3ggJpCgYs4EiAkkrXvMKYGYYNfY7Ip5e2aOiiNzJi8IobGjM3WFyvyBmECy2T2mE7MwhRQRYoItYPMrppXwrJQXUENMsPlsdo/JEkoZxbL/qJAq/rOD6PHSlEd+7Ojs0pzF5aAzrRO3U1PlgYCYQLIVFZMlrMRLVEwed9IF2fSy2+7WiipkbNpfZiAmkGx+jxmlubRVMIjHY048rnw2qcf1st7GZfiqCTGBZGsqpr97ZI7KMozR5/okKl9KRv14i0/Kyw3EBJLt6DHD3fhhXW6MltUn5bF4WsbaMk1l1cmkEUSFmECyVRWToKrJfz5xy3JKSuMrxST4U/Qow09jCYgJJHiv7EyAmECy2RVzi4CYQGLFfNXK+GroMf0yxBwfiAkkUUxfLSHmVEBMIPE95u+tkCHoMacBYgKJ7zGFmE09ZuqTvMYMnSHd5lsAJIWslLzcJOZU0HP/99n/tjYkJwCSYt+KSKFKyctzFJMO3tRBvQ1BxQQa12OykJSmHhMVc7igYgKN6zGlmMt6zKlAxQS7RpzKysrZT0z13tSMtK6Y7zywAr9oXrtKPDbjoGICTYYe07/pmw4u/obm3LStmG/fL8y9+w/M/usfJh9fyNUbZv/gDfM+36bWGSGomECTscecumJ+aF47eGDefvbY3Osq2cRiomICTcYec1gxV1ZMkuv+Y7tMgobprBPugRXVV/T91x/bx3jZVlX1eDGRnKiYQLM1Peb7r79o7r1TLUfxuOfUy3IKy7dqn2MFFRNorJivWBlfCT2mX968iklVMlQ9jhYutTwTMVExgSb0mF5Iykb2mCSWm8byWJjOvpOQUS7PRExUTKAJPWYl5ib2mHHqqsfoDO0GiImKCTRxKisr52ZVzMfmXupvlyQbT2n5fpOYbh80BaazumIfIwUVE2gy9pjDsapibnpQMYEmY485HMsr5uYHFRNoMvaYw4GKCXaNYv93VkgbVznDMirmuEHFBJoopqucMxYTFRPsEr7HDEJSlvWYU4fk3NZbACS+xxRizrXH3Ga2/ecD3dmYHnObgZhAszE95jYDMYGmU485FRAT7Bqhx/xLTJ8es/aV6vH76/Kx8sB1X5Un/g02A/wz1DeC5QNiAk2xZ2WkUKXk5S5iuq+6q75Msv7dkploJWZNGPHvyCkTxAQjEcWkStlHTI37VufMXyjZXUzLEBJBTDASrsdkISnr9ZhzqZhEuNqFHwu3Z2LaXRV6+1icBldfVCu/+Nb9slm2jzWAmEDjekwpZp8ek5Hf5pyTfmLSLwkr2aUQU4oUtwnr8cZxXFzG5rYNkif3sR4QE2jW7jGZoaQk+omZrphxHTkeql8VEtVXf7ofp+ZN+wh3+wIxgSZLjzmklEQvMaV48jY8XHt8xQXe/qyzkDyMQ0wwFOv3mJelP2jD3SHoLmbirGyjVKovpvE4beUprpoWuxUtep89gZhAs3aPWfsbZsgkZ2XVv2GhD9QS1e7TtJe3rfrNppM/6X30B2ICTbYec0i2/cCFmEBT7L1kZbRxlTMsQ8xxgZhA43vMICSlc485AhAT7Bq+xxRidu0xxwBigl3DTmVLK2Tpe8ywDDHHBWICTRTTV87lYiLDBQBJ6DG9kBT0mOMDMYEm9JiVmOgxxwdiAg16zBkAMYGmU485FRAT7BpZekz5trz4VriMrDxw6a1x4fllhvi3JFnzrXkQE2jW7zHpTey195zmf0N7KzG1GJnex9oKiAkyk7nHVBcdZ6KXmAP9kkgCMUFm8vaYdIDOsGLqK2Cqy8FKU8aLoS/TF0bH7VZfddL3I0cgJtBk+zsmH6zz6TEbfkGwsG6bIJtedkKr6h/H83/kCMQEGtdjvmCF5HTuMWuoi44z0UrMmgipi5+FtCwmb5Na1tu4kKh+33Q/10eOQEygKVhIqpS83F9MOiZn8vGVdFLKmUkVLlH55DapZbpdMS3P9ZEjEBNoopiycnYR001hq9I0k4pJ8JRTnQTis8hym+RyqurytJVFp3Xs8pofOQIxgcb1mC+89OeYPj2mPLmSu1oS/cSsxJIna1xoXblN07KTmrerqm7TyZ/w8OL9FUBMoPE95m+tlCHr9ZjDsO0HLsQEmoKFdJUzLEPMcYGYQBPFlJUTYo4LxAQa32MGISl9esyhgZhg10CPOQMgJtB06jGR4QKABD3mDICYQIMecwZATKBBjzkDICbQ4O+YMwBiAk3WHpPemjfJW/IIehtcfPtc/vfrOjq+1a4tEBNo8vWYQYxpxExcQbLiypBeQEwwEqHHPInp12P6qyzKMv8lX0SrXwoDCLMAxAQjYaeyXkhfOf1yZzHDtY9DXItJrD5w/ZUkC8+tReL77pY/VoQv5eJp8OqrSPp+hEgTEBNoopiycnYTs7recToxCS9nTa5lYuprKnmluI24jtOtXwlcu0ZT7r8nEBNoQo/phaR07TGljNOKKUhdDE3wfTkeZOMKWIldiR5/pqb9hbt9gZhAs2aPKatUldxydj9wQ7VrEkmO0zJXxgZyfYRIExATaIoXfmOFtHGVMyx3P/njmapiul5QNnvxQ6jFdJRIVlL/y6U2PY3TVjXdXfMjRJqAmEATxXSVc0PFJOqfHVvJ6KTlcSuXE2lBKBKYt636Tbmt+7n0dhATDITvMYOQlK495hhs+4ELMYHG9Zi/tEJyuvWY4wAxwa5RsJBUKXkZYo4LxASaKKasnBBzXCAm0Lgek4WkoMccH4gJNJ16TGSYAKCxU9mXrZAvhx7TL6fEBACMRxTTV06ICcAcCD2mF5LS1GMCAMYj9JiVmE09JgBgPNBjAjBD0GMCMEPQYwIwQ9BjAjBD0GMCMEPQYwIwQ3yP+WsrZAh6TACmx/eYQkz0mABMTyErJS9DTACmJYopKyfEBGBaQo/5pxj0mABMT+gxKzHRYwIwPXYqW1VKXoaYAExLFFNWTogJwLS4HvMXVkYOekwApsf1mFJM9JgATE8hKyUvQ0wApiWKKSsnxARgWtBjAjBD0GMCMEPQYwIwQ9BjAjBD0GMCMDuM+T82P0/sjOKI1gAAAABJRU5ErkJggg==)\

\

\


---

Original Source: https://www.mindstick.com/interview/23234/how-to-use-distinct-clause-in-sql-server

Copyright © MindStick Software Pvt. Ltd. This Markdown version is provided for developers, AI systems, and offline reading.