Collections:
Filerting out Duplications in Returning Rows in MySQL
How To Filter Out Duplications in Returning Rows in MySQL?
✍: FYIcenter.com
If there are duplications in the returning rows, and you want to remove the duplications, you can use the keyword DISTINCT in the SELECT clause. The DISTINCT applies to the combination of all data fields specified in the SELECT clause. The tutorial exercise below shows you how DISTINCT works:
mysql> CREATE TABLE fyi_team (first_name VARCHAR(8), last_name VARCHAR(8)); mysql> INSERT INTO fyi_team VALUES ('John', 'Gate'); mysql> INSERT INTO fyi_team VALUES ('John', 'Russell'); mysql> INSERT INTO fyi_team VALUES ('John', 'Seo'); mysql> INSERT INTO fyi_team VALUES ('John', 'Gate'); mysql> INSERT INTO fyi_team VALUES ('James', 'Gate'); mysql> INSERT INTO fyi_team VALUES ('Peter', 'Gate'); mysql> INSERT INTO fyi_team VALUES ('John', 'Gate'); mysql> SELECT * FROM fyi_team; +------------+-----------+ | first_name | last_name | +------------+-----------+ | John | Gate | | John | Russell | | John | Seo | | John | Gate | | James | Gate | | Peter | Gate | | John | Gate | | John | Gate | +------------+-----------+ 8 rows in set (0.00 sec) mysql> SELECT DISTINCT * FROM fyi_team; +------------+-----------+ | first_name | last_name | +------------+-----------+ | John | Gate | | John | Russell | | John | Seo | | James | Gate | | Peter | Gate | +------------+-----------+ 5 rows in set (0.00 sec) mysql> SELECT DISTINCT last_name FROM fyi_team; +-----------+ | last_name | +-----------+ | Gate | | Russell | | Seo | +-----------+ 3 rows in set (0.04 sec)
⇒ What Are Group Functions in MySQL
⇐ Using SELECT Statements in Views in MySQL
2018-01-06, 1342🔥, 0💬
Popular Posts:
How To Use SQL*Plus Built-in Timers in Oracle? If you don't have a stopwatch/timer and want to measu...
How To Create a Dynamic Cursor with the DYNAMIC Option in SQL Server Transact-SQL? If the underlying...
How To List All Stored Procedures in the Current Database in SQL Server Transact-SQL? If you want to...
Can You Drop an Index Associated with a Unique or Primary Key Constraint in Oracle? You can not dele...
How To Drop a Stored Procedure in Oracle? If there is an existing stored procedure and you don't wan...