Collections:
Filter Out Duplications in Returning Rows in Oracle
How To Filter Out Duplications in Returning Rows in Oracle?
✍: FYIcenter.com
If there are duplications in the returning rows, and you want to remove the duplications, you can use the keyword DISTINCT or UNIQUE in the SELECT clause. The tutorial exercise below shows you that DISTINCT works on selected columns only:
SQL> CREATE TABLE fyi_team AS SELECT first_name, last_name FROM employees WHERE first_name = 'John'; Table created. SQL> INSERT INTO fyi_team VALUES ('John', 'Chen'); SQL> INSERT INTO fyi_team VALUES ('James', 'Chen'); SQL> INSERT INTO fyi_team VALUES ('Peter', 'Chen'); SQL> INSERT INTO fyi_team VALUES ('John', 'Chen'); SQL> SELECT * FROM fyi_team; FIRST_NAME LAST_NAME -------------------- ------------------------- John Chen John Russell John Seo John Chen James Chen Peter Chen John Chen SQL> SELECT DISTINCT * FROM fyi_team; FIRST_NAME LAST_NAME -------------------- ------------------------- Peter Chen John Chen James Chen John Seo John Russell SQL> SELECT DISTINCT last_name FROM fyi_team; LAST_NAME ------------------------- Chen Russell Seo
⇒ What Are Group Functions in Oracle
⇐ Use of SELECT Statements in Views in Oracle
2019-12-19, 1421🔥, 0💬
Popular Posts:
How To Create a Table Index in Oracle? If you have a table with a lots of rows, and you know that on...
Where to find answers to frequently asked questions on PHP Connections and Query Execution for MySQL...
Where to find SQL Server database server tutorials? Here is a collection of tutorials, tips and FAQs...
How To Verify Your PHP Installation in MySQL? PHP provides two execution interfaces: Command Line In...
How Fixed Length Strings Are Truncated and Padded in SQL Server Transact-SQL? When the length of the...