SQL exercises on SCALAR FUNCTIONS

This page lists the 6 exercises about Scalar functions in SQL on our website:

Software: SQL
Version: Any version of SQL Server
Topic: Scalar functions
Level: Relatively easy
Course: Advanced SQL
Exercise: Use a scalar function to include each Dr Who's incarnation dates in a query.

Go to exercise ...

Software: SQL
Version: Any version of SQL Server
Topic: Scalar functions
Level: Relatively easy
Course: Advanced SQL
Exercise: Count the number of letters for an event using a scalar function.

Go to exercise ...

Software: SQL
Version: Any version of SQL Server
Topic: Scalar functions
Level: Average difficulty
Course: Advanced SQL
Exercise: Use an SQL function within a query to find out the part number of any Dr Who episode.

Go to exercise ...

Software: SQL
Version: Any version of SQL Server
Topic: Scalar functions
Level: Average difficulty
Course: Advanced SQL
Exercise: Create a function to take in any month number and return the month name.

Go to exercise ...

Software: SQL
Version: Any version of SQL Server
Topic: Scalar functions
Level: Harder than average
Course: Advanced SQL
Exercise: Create all sorts of scalar functions in SQL to return info about Dr Who episodes from within a query.

Go to exercise ...

Software: SQL
Version: Any version of SQL Server
Topic: Scalar functions
Level: Harder than average
Course: Advanced SQL
Exercise: Use a CASE statement to classify each event according to whether it is the top of its class or not.

Go to exercise ...

You can search our full list of SQL exercises here, or why not have a look at our other SQL training resources?

This page has 0 threads Add post