Retrieving Data Using the SQL SELECT Statement

Select Operations

1. Select + WHERE..................................View Examples                        
2. Select + JOIN     .................................View Examples
3. Select + GROUP BY       
4. Select + HAVING
5. Select + (AND, OR, NOT)
6. Select + SUB QUERY
7. Select + ORDER BY
8. Select + Views
9. Select + Materialized Views
10. Select + Metadata tables.