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 1423 03 May 2017

Ask by Manish Kumar

Updated 18 Sep 2020

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

Markdown for AI

A clean, structured version of this page for AI assistants and LLMs.