Sql remove duplicate when select table

Question

I have a table in my sql that have names and cities for example.

I want to make a Select Command that get all the cities and remove from the result the duplicates.

for the select i am using:

        string citiesSelect = "SELECT [city] FROM [people] ORDER BY [city]";
        CitiesDataSource.SelectCommand = citiesSelect;
        CitiesDataSource.Select(DataSourceSelectArguments.Empty);
        DropDownList2.DataSourceID = CitiesDataSource.ID;

you can either go for distinct or with group by option....

Pranay Rana
– Pranay Rana

2012-02-08 13:40:04 +00:00
Commented Feb 8, 2012 at 13:40 — Pranay Rana
– Pranay Rana, Commented Feb 8, 2012 at 13:40

Shai · Accepted Answer · 2012-02-08 13:10:34Z

4

use DISTINCT.

 string citiesSelect = "SELECT DISTINCT [city] FROM [people] ORDER BY [city]";
        CitiesDataSource.SelectCommand = citiesSelect;
        CitiesDataSource.Select(DataSourceSelectArguments.Empty);
        DropDownList2.DataSourceID = CitiesDataSource.ID;

answered Feb 8, 2012 at 13:10

Shai

25.7k9 gold badges48 silver badges69 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Mohammed Swillam · Accepted Answer · 2012-02-08 13:10:54Z

0

Consider the following line:

string citiesSelect = "SELECT DISTINCT [city] FROM [people] ORDER BY [city]";

answered Feb 8, 2012 at 13:10

Mohammed Swillam

9,2524 gold badges38 silver badges47 bronze badges

Comments

vc 74 · Accepted Answer · 2012-02-08 13:11:12Z

0

Try this query:

SELECT DISTINCT [city] FROM [people] ORDER BY [city]

The documentation for DISTINCT can be found here.

answered Feb 8, 2012 at 13:11

vc 74

38.3k7 gold badges80 silver badges96 bronze badges

Collectives™ on Stack Overflow

Sql remove duplicate when select table

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related