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 Use Subqueries with the IN Operator
How To Use Subqueries with the IN Operator? - Oracle DBA FAQ - Understanding SQL SELECT Query Statements
✍: FYIcenter.com
A subquery can be used with the IN operator as "expression IN (subquery)". The subquery should return a single column with one or more rows to form a list of values to be used by the IN operation. The following tutorial exercise shows you how to use a subquery with the IN operator:
SQL> SELECT first_name, last_name FROM employees 2 WHERE department_id IN ( 3 SELECT department_id FROM departments 4 WHERE location_id = 1700 5 ); FIRST_NAME LAST_NAME -------------------- ------------------------- Steven King Neena Kochhar Lex De Haan Nancy Greenberg Daniel Faviet John Chen Ismael Sciarra ......
2007-04-19, 5246👍, 0💬
Popular Posts:
When should the register modifier be used? Does it really help? The register modifier hints to the c...
How To Use "IF" Statements on Multiple Conditions? - Oracle DBA FAQ - Understanding PL/SQL Language ...
What is cross page posting? By default, button controls in ASP.NET pages post back to the same page ...
What will be printed as the resultof the operation below: int x; int modifyvalue() { return(x+=10); ...
What is the difference between "printf(...)" and "sprintf(...)"? sprintf(...) writes data to the cha...