Oracle PLSQL Subquery 72 codes

  1. Home
  2. Oracle PLSQL
  3. Subquery
1 A correlated subquery
2 A correlated subquery references one or more columns in the outer query
3 All locations, where courses are offering, have no departments (subquery)
4 ALL with a Multiple Row Subquery
5 An example of a nested three-level subquery
6 ANY
7 ANY with a Multiple Row Subquery
8 Born after employee 4 was born
9 Compare with data from subquery
10 Compare with the sub query result
11 Correlated subquery using the EXISTS operator
12 Delete and subquery
13 EXISTS typically offers better performance than IN with subqueries
14 Exists in subquery
15 First three rows from subquery
16 Format result from subquery
17 Get Categories and Products (with Correlated Subqueries)
18 Greater than all subquery
19 Greater than any subquery
20 Greater than average salary
21 Greater than max(salary)
22 How Many Products By Department with correlated subqueries 2
23 If an inner query returns a NULL, the outer query also returns NULL
24 In and subquery
25 In subquery
26 Inline view
27 Inner query Demo
28 Larger than value from subquery
29 Multiple Row Subqueries
30 Multiple-row subqueries return more than one row of result from the subquery
31 Not equals and subquery
32 Not exists and subquery
33 Not exists subquery
34 Not in and subquery
35 NVL() is used to convert null in correlated query
36 Select from virtual table (sub query) with rownum
37 Selecting Products That Belong to Department with Subquery
38 Simple Subqueries in select statement
39 Single Row Subqueries May Return a Maximum of One Row
40 Single-row subqueries return only one row of result
41 Sub query
42 Sub query with table join
43 Subqueries in a FROM Clause (Inline Views)
44 Subqueries in a HAVING Clause
45 Subqueries in the SELECT column list (New Way)
46 Subqueries in the SELECT column list (Old way)
47 Subqueries in the WHERE Clause
48 Subqueries May Not Contain an ORDER BY Clause
49 Subqueries That Return Multiple Results
50 Subquery in from clause
51 Subquery in select statement
52 Subquery in update statement
53 Subquery in where clause
54 Subquery just returns a literal value
55 The parent query of a single-row subquery can return more than one row
56 To delete the records of emps whose salary is below the average salary in the department (correlated subquery)
57 To update the salary of all emps to the maximum salary in the corresponding department (correlated subquery)
58 Use aggregate function in sub query
59 Use sub query as a virtual table
60 Using EXISTS with a Correlated Subquery
61 Using NOT EXISTS with a Correlated Subquery
62 Using Set Membership with Subqueries
63 Using subquery in the SET clause of UPDATE statement
64 Using the ALL Operator with subquery
65 Using the ANY Operator with subquery
66 Using the EXISTS and NOT EXISTS operators
67 Using the EXISTS Operator with subquery
68 When a query is ALL, each row in the result set is greater than the highest value returned
69 Working with multi-column subqueries
70 Writing Multiple Column Subqueries with table join
71 Writing Nested Subqueries
72 Writing Single Row Subqueries