The SQL SELECT DISTINCT Statement
In a table, some of the columns may contain duplicate values. This
is not a problem, however, sometimes you will want to list only the different
(distinct) values in a table.The DISTINCT keyword can be used to return only distinct (different) values.
SQL SELECT DISTINCT Syntax
SELECT DISTINCT column_name(s)
FROM table_name |
SELECT DISTINCT Example
The "Persons" table:
Id
|
LastName
|
FirstName
|
Address
|
City
|
1
|
Navis
|
Anto
|
Madras
|
TVL
|
2
|
ji
|
Bala
|
Bombay
|
TVL
|
3
|
Christopher
|
Franklin
|
America
|
KK
|
Now we want to select only the distinct values from the column named "City" from the table above.
We use the following SELECT statement:
SELECT DISTINCT City FROM Persons
|
The result-set will look like this:
City
|
TVL
|
KK
|
0 comments:
Post a Comment