How to Work with Data Manipulation Functions

  • google plus

In Brief...

An aggregate function derives it value from an aggregation, or group, of values. A data manipulation function (also known as a "scalar function") derives its value from a single column value. For example, we can convert a character column value to all uppercase or lowercase.

Take our Introduction to SQL Training course for free.

See the Course Outline and Register

Instructions

To learn how work with data manipulation functions in a SQL select statement, follow these steps:

  1. You'll need to setup the MySQL database tables. The instructions for the setup can be found in How to add comments in simple SQL selects. Follow steps 1 through 7 before proceeding to the next step.
  2. Now we'll explore a couple of data manipulation functions using one select statement.
  3. Imagine we are required to display each city name in upper case and lower case. Execute the following statement:
    Display city names in upper case and lower case
    The upper data manipulation function returns its argument in upper case. The lower data manipulation function returns its argument in lower case.

Webucator provides instructor-led training to students throughout the US and Canada. We have trained over 90,000 students from over 16,000 organizations on technologies such as Microsoft ASP.NET, Microsoft Office, XML, Windows, Java, Adobe, HTML5, JavaScript, Angular, and much more. Check out our complete course catalog.

Categories

Courses

Author: Stephen Withrow

Stephen has over 30 years' experience in training, development, and consulting in a variety of technology areas including Java, C, C++, XML, JavaScript, AJAX, Tomcat, JBoss, Oracle, and DB2. His background includes design and implementation of business solutions on client/server, Web, and enterprise platforms. Stephen is a published writer in both technical and non-technical endeavors. Stephen received an undergraduate degree in Computer Science and Physics from Florida State University.

Discuss