1.DML Statements

  1. DMl Statements

    1. SELECT Statement

      1. WHERE

      2. GROUP BY

      3. WITH CUBE or WITH ROLLUP

      4. HAVING

      5. SELECT

      6. DISTINCT

      7. ORDER BY

      8. TOP

    2. Joins Types

      1. INNER JOINS

      2. OUTER JOINS

        1. LEFT JOIN or LEFT OUTER JOIN

        2. RIGHT JOIN or RIGHT OUTER JOIN

        3. FULL JOIN or FULL OUTER JOIN

      3. CROSS JOIN

      4. GROUPING

      5. Union

      6. Union ALL

      7. ROLL UP

      8. MERGE

    1. Advance Query Techniques

      1. Common Table Expression (Recursive Queries)

      2. Correlated Vs No Correlated Queries

      3. Ranking Function

      4. SubQueries

    1. Typical query Examples