forum

Home / DeveloperSection / Forums / SQL Query to Get Distinct Values from a Column in SQL Server

Ask Question
Ravi Vishwakarma

Ravi Vishwakarma

Follow
Ravi Vishwakarma is a dedicated Software Developer with a passion for crafting efficient and innovative solutions. With a keen eye for detail and years of experience, he excels in developing robust software systems that meet client needs. His expertise spans across multiple programming languages and technologies, making him a valuable asset in any software development project.

Can you answer this question?

Answer

1 Answers

Ravi Vishwakarma

Ravi Vishwakarma

16-Jul-2024

To get distinct values from a column in SQL Server, you can use the SELECT DISTINCT statement. This query will return all unique values from the specified column.

Here’s the basic syntax:

SELECT DISTINCT column_name
FROM table_name;

Example

Assume you have a table called Customers and you want to get all distinct values from the City column:

SELECT DISTINCT City
FROM Customers;

This query will return a list of unique cities from the City column in the Customers table.

Multiple Columns

If you want to get distinct combinations of values from multiple columns, you can include multiple columns in the SELECT statement:

SELECT DISTINCT column1, column2
FROM table_name;

For example, to get distinct combinations of City and Country from the Customers table:

SELECT DISTINCT City, Country
FROM Customers;

Ordering the Results

You can also order the distinct values using the ORDER BY clause:

SELECT DISTINCT City
FROM Customers
ORDER BY City;

This query will return the distinct cities in alphabetical order.

Liked By