Using Single Row Functions to Customize Output

Introduction

Using Single Row Functions to Customize Output

This module explores the concepts of single row functions to customize the output in relational tables.

• Describe various types of functions available in SQL
• Using various Single Row Functions in a SELECT statement

Exercise 1 - Functions Available in SQL

In this exercise, you will learn the following about the single row functions:

• Establishing a Connection to the Database
• Distinct Types of Single Row Functions

Exercise 2 - Using General Functions in SELECT statements

In this exercise you will learn the following about the single row functions:

• Use Numeric Functions in a SELECT Statement
• Use Character Functions in a SELECT Statement
• Use Datetime Functions in a SELECT Statement
• Use Conversion Functions in a SELECT Statement
• Use General Functions in a SELECT Statement