Working With SubQueries

This topic describes working with subqueries used in criteria expressions to limit the resulting dataset in WHERE, HAVING, and SELECT clauses.

You may add a subquery as part of the expression or condition in Apply Operations while editing text in a cell.

Note: The subquery should be fully qualified manually; it does not get fully qualified by itself.

Example

Let us consider a "dbo"."Customers" table with below records:

ID     AGE      SALARY
1       30        2000
2       35        4000
3       40        6000

Now, if we enter below subquery with a SELECT statement:

Select * from "dbo"."Customers"
WHERE ID IN (Select ID from "dbo"."Customers" WHERE SALARY > 2500);

This would give us below result:

ID     AGE      SALARY
2       35        4000
3       40        6000