SQL Query to Get Distinct Values from a Column in SQL Server

Question

Ravi Vishwakarma · Answer

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.

forum

SQL Query to Get Distinct Values from a Column in SQL Server

ICSM Computer

Can you answer this question?

1 Answers

Multiple Columns

Ordering the Results

Liked By