SQL PHP HTML ASP JavaScript articles and free scripts to download
 

SQL DISTINCT Command

DISTINCT command in SQL collects the unique or distinct records from a field of a table. In the student table we are interested to know how many class records are there and the DISTINCT sql command should return class once only. So if class five is there ten times then it should return once and if class six one record is there then class six should return once.  

So using DISTINCT sql command we can avoid duplicate records in SELECT query

There is another related command sql group by which groups the data and brings the unique names. This group by command is usually used along with count, average, minimum, maximum commands. Here we will discuss sql distinct command only


DISTINCT command will return records once only.

SELECT DISTINCT class FROM student
This is our table and we will apply DISTINCT command to this table.
id name class mark
1 John Deo Four 75
2 Max Ruin Three 85
3 Arnold Three 55
4 Krish Star Four 60
5 John Mike Four 60
6 Alex John Four 55
Related Tutorial
Group by
SQL Maximum value
SQL Average
SQL Rename table
PHP MySQL functions
Here again the DISTINCT command in SQL
SELECT DISTINCT class FROM `student`
The output is displayed here
class
Four
Three
As you can see only two rows are returned and they are the distinct class in the table

Discuss this tutorial at forum

List of SQL Tutorials


 
Scripts
PHP
JavaScript
HOME
SQL Tutorial List
SQL (Home)
SQL Commands
Subscribe
Submit your email address and receive article and product notifications. Your email is safe with us.