Course Description
Database tables hold a large number of rows, which are often not sorted in any specific order. Learn how to selectively return only a subset of rows, sorted and customized.
Learning Objectives
Oracle Database 12c R2 SQL: Restricting and Sorting Data
- describe the limiting of rows selected in a query and how to use the WHERE clause in a SQL statement
- use character strings and dates in a WHERE clause in a SQL statement
- use the comparison operators in a WHERE clause in a SQL statement
- use the BETWEEN and IN operators in a WHERE clause in a SQL statement
- use the LIKE operator and combine wildcard characters in a WHERE clause in a SQL statement
- use the NULL and logical operator conditions in a WHERE clause in a SQL statement
- use the AND, OR, and NOT operators in a WHERE clause in a SQL statement
- define the rules of precedence in a WHERE clause in a SQL statement
- use the ORDER BY clause to sort the data returned by a SQL statement
- use the ROW_LIMITING_CLAUSE to limit the number of rows returned by a SQL statement
- use substitution variables
- manipulate data using SQL