|
| |
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 |
|
|
Here again the DISTINCT command in SQL
SELECT
DISTINCT class
FROM
`student`
The output is
displayed here
As you can see only two rows are returned and they are the distinct class in the
table
| |
|
| 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.
|
|
|
|
