Restricting Output
Oracle 12c
| Beginner
- 10 videos | 44m 49s
- Earns a Badge
Database tables often hold a large number of rows, which aren't necessarily sorted. Learn how to selectively return only a subset of rows, sorted and customized, using operators, conditions, wildcards, and clauses.
WHAT YOU WILL LEARN
-
describe the limiting of rows selected in a query and how to use the WHERE clause in a SQL statementuse character strings and dates in a WHERE clause in a SQL statementuse the comparison operators in a WHERE clause in a SQL statementuse the BETWEEN and IN operators in a WHERE clause in a SQL statementuse 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 statementuse the AND, OR and NOT operators in a WHERE clause in a SQL statementdefine the rules of precedence in a WHERE clause in a SQL statementuse the ORDER BY clause to sort the data returned by a SQL statementuse the ROW_LIMITING_CLAUSE to limit the number of rows returned by a SQL statement
IN THIS COURSE
-
3m 34sAfter completing this video, you will be able to describe how to limit the rows selected in a query and how to use the WHERE clause in a SQL statement. FREE ACCESS
-
4m 37sIn this video, find out how to use character strings and dates in a WHERE clause in a SQL statement. FREE ACCESS
-
3m 5sIn this video, learn how to use comparison operators in a WHERE clause in a SQL statement. FREE ACCESS
-
4m 16sTo use the BETWEEN and IN operators in a WHERE clause in a SQL statement: FREE ACCESS
-
3m 47sIn this video, you will use the LIKE operator and combine wildcard characters in a WHERE clause of a SQL statement. FREE ACCESS
-
2m 57sDuring this video, you will learn how to use the NULL and logical operator conditions in a WHERE clause in a SQL statement. FREE ACCESS
-
7m 21sIn this video, learn how to use the AND, OR, and NOT operators in a WHERE clause in a SQL statement. FREE ACCESS
-
4m 47sIn this video, find out how to define the rules of precedence in a WHERE clause in a SQL statement. FREE ACCESS
-
5m 14sLearn how to use the ORDER BY clause to sort the data returned by a SQL statement. FREE ACCESS
-
5m 13sIn this video, learn how to use the ROW_LIMITING_CLAUSE to limit the number of rows returned by a SQL statement. FREE ACCESS
EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE
Skillsoft is providing you the opportunity to earn a digital badge upon successful completion on some of our courses, which can be shared on any social network or business platform.
Digital badges are yours to keep, forever.