Blog Details

SELECT DISTINCT Statement


                                
                                    <h2>*<span style="text-decoration: underline;"> The SQL SELECT DISTINCT Statement</span></h2>
<ul>
	<li><span style="font-size: 13px;">In a table, a column may contain <strong>many duplicate values;</strong> and sometimes you only want to <strong>list the different (distinct) values.</strong></span></li>
	<li><span style="font-size: 13px;">The <strong>DISTINCT keyword</strong> can be used to <strong>return</strong> only<strong> distinct (different) values.</strong></span></li>
</ul>
&nbsp;
<h2>Syntax :</h2>
<h3>SELECT DISTINCT <em>column_name</em>,<em>column_name</em>
FROM <em>table_name</em>;</h3>
&nbsp;
<h2>Example :</h2>
<h3>SELECT DISTINCT City FROM Customers;</h3>
<h3></h3>
                                    


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