---
title: "SQL SERVER DISTINCT CLAUSE"  
description: "SQL SERVER DISTINCT CLAUSE"  
author: "Anonymous User"  
published: 2015-11-05  
updated: 2015-11-06  
canonical: https://www.mindstick.com/forum/33571/sql-server-distinct-clause  
category: ".net"  
tags: ["sql server"]  
reading_time: 1 minute  

---

# SQL SERVER DISTINCT CLAUSE

what is use of [distinct](https://www.mindstick.com/forum/159558/why-c-sharp-linq-distinct-doesn-t-work) [clause](https://www.mindstick.com/forum/33937/difference-between-throw-exception-and-throw-clause) in sqlserver.

## Replies

### Reply by John Smith

You can check following article also \
http://www.mindstick.com/Articles/66d1ba5a-2c92-4497-8cfe-3bb90b87c9ba/Select%20Command%20in%20SQL%20Server\
\

### Reply by Anonymous User

The SQL Server (Transact-SQL) DISTINCT clause is used to remove duplicates from the result set. The DISTINCT clause can only be used with SELECT statements.

Select normal query

**Write semple query in sqlserver.**

\

```
select  Emp_Name ,Emp_Sal  from Employee result: 
```

```
Use Distinct clause select query
select distinct Emp_Name ,Emp_Sal  from Employee   
```


---

Original Source: https://www.mindstick.com/forum/33571/sql-server-distinct-clause

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