Categories:
.NET (357)
C (330)
C++ (183)
CSS (84)
DBA (2)
General (7)
HTML (4)
Java (574)
JavaScript (106)
JSP (66)
Oracle (114)
Perl (46)
Perl (1)
PHP (1)
PL/SQL (1)
RSS (51)
Software QA (13)
SQL Server (1)
Windows (1)
XHTML (173)
Other Resources:
How To Filter Out Duplications in the Returning Rows
How To Filter Out Duplications in the Returning Rows? - Oracle DBA FAQ - Understanding SQL SELECT Query Statements
✍: 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
2007-04-20, 4940👍, 0💬
Popular Posts:
How To Use SELECT Statement to Count the Number of Rows? - Oracle DBA FAQ - Understanding SQL SELECT...
Does it matter in what order catch statements for FileNotFoundException and IOExceptipon are written...
How many types of validation controls are provided by ASP.NET ? There are six main types of validati...
What is more advisable to create a thread, by implementing a Runnable interface or by extending Thre...
How To Download and install PSP Evaluation? - PSP Tutorials - Fading Images to Background Colors wit...