'Sql select round 45' diaporamas de présentation

Ch. 3 Single-Row Functions

573 views • 45 slides

Single-Row Functions

Single-Row Functions. Objectives. After completing this lesson, you should be able to do the following: Describe various types of functions available in SQL Use character, number, and date functions in SELECT statements Describe the use of conversion functions. Input. Output. arg 1. arg 2.

598 views • 44 slides

Single-Row Functions

Single-Row Functions. SQL Functions. Input. Output. arg 1. arg 2. Result value. arg n. Function. Function performs action. int inc() { static int i = 0; int j=0; j++; i++; return i; }. Two Types of SQL Functions. Functions. Multiple-row functions. Single-row

750 views • 43 slides

Single-Row Functions

Single-Row Functions. Objectives. After completing this lesson, you should be able to do the following: Describe various types of functions available in SQL Use character, number, and date functions in SELECT statements Describe the use of conversion functions. Input. Output. arg 1. arg 2.

584 views • 42 slides