interview

home / developersection / interviews / how to use distinct clause in sql server?

How to Use Distinct Clause in Sql Server?

Manish Kumar 1330 03-May-2017

sql server

Updated on 18-Sep-2020

Manish Kumar

Other

Message

Can you answer this question?

1 Answers

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