Select

• Select
• Simple select statement
• Column
• ROWID / ROWNUM
• Arithmetic
• Distinct
• NULL
• Where
• DUAL Table
• SQL Comparison Operators
• ALL,ANY
• AND, OR, and NOT
• BETWEEN ... AND matches a range of values
• IN matches lists of values
• LIKE(NOT LIKE) matches patterns in strings
• IS NULL(IS NOT NULL) matches null values
• Group
• Having
• Order
• Join
• What is table join
• Inner Join
• Outer Join, Right Outer Join, Left Outer Join
• Set Operators
• UNION ALL, UNION, INTERSECT, MINUS
• CASE
• Hierarchical Queries