MSSQL Tutorial Subquery 30 codes

1 A correlated subquery relies on the main query for its processing

2 A query that required a derived table

3 A query that uses a correlated subquery in its SELECT clause to retrieve the most recent Billing for each Banker

4 A query that uses three subqueries

5 A subquery can be used with other comparison operators

6 ALL with subquery

7 Building a Nested Subquery

8 Correlated subquery using Group By

9 Correlated subquery using TOP 1

10 Creating a Derived Table

11 Delete with subquery

12 Doing calculation with subquery

13 Finding First Employee Using a Derived Table

14 ID NOT IN (SELECT ID FROM Title)

15 In-Line Views (Derived Tables)

16 Join and sub query

17 Join with (inline)Table Expressions

18 Queries in the FROM Clause

19 Select from nested select statements

20 SELECT list FROM (query that returns a regular result set) AS alias name JOIN some other base or derived table

21 Subqueries and Comparison Operators

22 Subqueries and Derived Tables

23 Subqueries and IN Operator

24 Subqueries are SELECT statements that are nested within another T-SQL statement

25 Subqueries can be nested

26 Subquery returned more than 1 value This is not permitted when the subquery follows =, !=, , = , , = or when the subquery is used

27 Subquery with =

28 Using SELECT DISTINCT or a GROUP BY statement in the inner query

29 Using Subqueries to Check for the Existence of Matches

30 Using Subqueries to Check for the Existence of Matches between two tables