Products

Data Converter Cleaner TUC - Unit Converter Import Export Survey Manager Tweet Controller

Developer

Article Blog Forum Interview Beginner News Startup Quiz

Users

Career

Apply Job Internship

Pricing

Login Sign Up Get a Quote

How to Use Distinct Clause in Sql Server?

Manish Kumar 1367 03 May 2017

Manish Kumar

Other

1 Answers

Manish Kumar 03 May 2017

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 Expression
From
TableName
Where
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.

Select Distinct Name from
Test.dbo.Employee

advertising