Restricting Output

Oracle 12c    |    Beginner
  • 10 Videos | 45m 49s
  • Earns a Badge
Likes 93 Likes 93
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 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

IN THIS COURSE

EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE

Skillsoft is providing you the opportunity to earn a digital badge upon successful completion of this course, which can be shared on any social network or business platform

Digital badges are yours to keep, forever.

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Likes 57 Likes 57  
Likes 57 Likes 57  
COURSE SQL Developer
Likes 285 Likes 285