SQL Getting Started

Scalar Fullselects

A scalar fullselect is a fullselect within parentheses that returns one row containing only one column value. Scalar fullselects are useful for retrieving data values from the database for use in an expression.

• The following example lists names of employees who have a salary greater than the average salary of all employees:

   
       SELECT LASTNAME, FIRSTNME
          FROM EMPLOYEE
          WHERE  SALARY > (SELECT AVG(SALARY)
                             FROM EMPLOYEE) 
  

• This example finds the average salary of the employees in two different tables:

   
       SELECT AVG(SALARY) AS "Average_Employee",
              (SELECT AVG(SALARY) AS "Average_Staff" FROM STAFF)
                  FROM EMPLOYEE
  

[ DB2 List of Books | Search the DB2 Books ]