Oracle - Use Subqueries with the IN Operator in Oracle

Use Subqueries with the IN Operator in Oracle

Q

How To Use Subqueries with the IN Operator in Oracle?

✍: FYIcenter.com

A

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
......

⇒Understanding SQL SELECT Query Statements in Oracle

⇒⇒Oracle Database Tutorials

2019-09-27, 530👍, 0💬

💬 2019-09-19 Aninda mahadev: Good Tutorial!!!

Use Subqueries with the EXISTS Operator in Oracle
How To Use Subqueries with the EXISTS Operator in Oracle? A subquery can be used with the EXISTS operator as "EXISTS (subquery)", which returns true if the subquery returns one or more rows. The following statement is a good example of "EXISTS (subquery)". It returns rows from employees table that t... 2019-09-27, 685👍, 0💬

What Is a Subquery in Oracle
What Is a Subquery in Oracle? A subquery is a SELECT statement used as part of the selection criteria of the main SELECT statement. The subquery specified in the WHERE clause will be evaluated repeated on each row of the selection base table. The output of the subquery will be used in the final eval... 2019-09-27, 644👍, 0💬

Use Subqueries in the FROM Clause in Oracle
How To Use Subqueries in the FROM Clause in Oracle? If you have a query returning many rows of data, and you want to perform another query on those rows, you can put the first query as a subquery in the FROM clause of the second query. The following statement shows you how to use a subquery as base ... 2019-09-27, 566👍, 0💬

Use Subqueries with the IN Operator in Oracle
How To Use Subqueries with the IN Operator in Oracle? 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 ... 2019-09-27, 531👍, 0💬

All rights in the contents of this web site are reserved by the individual author. fyicenter.com does not guarantee the truthfulness, accuracy, or reliability of any contents.