Data Structure
Networking
RDBMS
Operating System
Java
MS Excel
iOS
HTML
CSS
Android
Python
C Programming
C++
C#
MongoDB
MySQL
Javascript
PHP
Physics
Chemistry
Biology
Mathematics
English
Economics
Psychology
Social Studies
Fashion Studies
Legal Studies
- Selected Reading
- UPSC IAS Exams Notes
- Developer's Best Practices
- Questions and Answers
- Effective Resume Writing
- HR Interview Questions
- Computer Glossary
- Who is Who
How to order return duplicate column values only once in MySQL?
To return a column value only once in MySQL, let us first see an example and create a table −
mysql> create table DemoTable680(Status varchar(100)); Query OK, 0 rows affected (0.75 sec)
Insert some records in the table using insert command −
mysql> insert into DemoTable680 values('Busy');
Query OK, 1 row affected (0.36 sec)
mysql> insert into DemoTable680 values('At Work');
Query OK, 1 row affected (0.16 sec)
mysql> insert into DemoTable680 values('Busy');
Query OK, 1 row affected (0.12 sec)
mysql> insert into DemoTable680 values('Blocked');
Query OK, 1 row affected (0.28 sec)
mysql> insert into DemoTable680 values('Offline');
Query OK, 1 row affected (0.67 sec)
mysql> insert into DemoTable680 values('Offline');
Query OK, 1 row affected (0.23 sec)
mysql> insert into DemoTable680 values('Blocked');
Query OK, 1 row affected (0.14 sec)Display all records from the table using select statement −
mysql> select *from DemoTable680;
This will produce the following output −
+---------+ | Status | +---------+ | Busy | | At Work | | Busy | | Blocked | | Offline | | Offline | | Blocked | +---------+ 7 rows in set (0.00 sec)
Following is the query to return duplicate column values only once in MySQL -
mysql> select distinct Status from DemoTable680 order by Status;
This will produce the following output −
+---------+ | Status | +---------+ | At Work | | Blocked | | Busy | | Offline | +---------+ 4 rows in set (0.00 sec)
Updated on: 26-Aug-2019
94 Views
Advertisements