Blog Details

SELECT DISTINCT Statement



                                

* The SQL SELECT DISTINCT Statement

  • In a table, a column may contain many duplicate values; and sometimes you only want to list the different (distinct) values.
  • The DISTINCT keyword can be used to return only distinct (different) values.
 

Syntax :

SELECT DISTINCT column_name,column_name FROM table_name;

 

Example :

SELECT DISTINCT City FROM Customers;


Categories

Php mysql

Latest posts

13.05.14
Implementing CRUD Operations ¶

<ul> <li>Now comes the fun part. We would like t

13.05.14
View

<ol> <li><a href="http://www.yiiframework.com/do

13.05.14
Creating Model

<ol> <li><a href="http://www.yiiframework.com/do

Get Free Quote