Expressions and Single Row functions in SQL

Communicator
Tools
Profile Settings

Loading, please wait ...

Open its course - Database Systems Labs

Expressions and Single Row functions in SQL By Ali Iqbal
Summary

Summary

4
Teachers with
Ali Iqbal 19
Followers
For Learning All
Visibility
Security Status 2
Contributions
By Teachers

Notes

Students are auto-evaluated against related topics to ensure they learned it.

This lab focus on different expressions and single row functions

Overview

Expression and single row functions can be used for runtime data minupulation and are a power feature in SQL. Single row functions are those built-in functions which work on a single row and return one output per row. For example, length and case conversion functions are single row functions. Proper use of such functions inside SQL statements can greatly save coding on the caller side i.e. PHP, Java etc.

Objectives

Using Expressions
Applying single-row functions.

Expressions in SQL for All, By Ali Iqbal

To be updated soon

Lab Tasks for All, By Ali Iqbal

Create a table with two columns for first_name and family_name respectively. Insert the names of your three friends in lower case case characters. Write a query to create columns aliased fullname by using the CONCAT() functions.
Every student has to find at least 5 examples of string, date and math functions.
Merge your examples into the common solution section of your group lab such that same functions appears togather.