8 - SQL Functions Querys

Contents

After this lesson, the learner will be able to use all the following query commands described in Lesson 8 - SQL Functions Querys to retrieve data from database tables:

  • CONCAT
  • LOWER
  • UPPER
  • LPAD
  • RPAD
  • SUBSTR
  • INSTR
  • LTRIM
  • RTRIM
  • LENGTH
  • REPLACE
  • Math operators
  • ROUND
  • CEIL
  • FLOOR
  • SIGN
  • MOD
  • DATEFORMAT
  • CURDATE
  • DATEDIF
  • ADDTIME
  • IFNULL


Tasks:

  • Lesson 8 - SQL Functions Querys
  • (8)  Function Querys SQL Exercises

Last modified: Wednesday, 12 April 2023, 2:10 PM