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, 1318🔥, 0💬
Popular Posts:
How To Break Query Output into Pages in MySQL? If you have a query that returns hundreds of rows, an...
What Is the Difference Between GETDATE() and GETUTCDATE() in SQL Server Transact-SQL? The difference...
What are binary literals supported in SQL Server Transact-SQL? Binary literals in Transact-SQL are s...
What is test testing area for? The testing area is provided to allow visitors to post testing commen...
How To Convert Character Strings into Numeric Values in SQL Server Transact-SQL? Sometimes you need ...