-->IF A SUBQUERY RETURNS MORE THAN ONE VALUE WE CALL IT AS MULTI ROW SUBQUERY. --> IF SUBQUERY RETURNS MORE THAN ONE VALUE alter WE CANNOT USE NORMAL OPERATORS.

-- Write a query to find the name of the employee with the highest salary in the company. -- Write a query to find the name of the employee who has been working in the company for the longest time. -- ...

Note: This example uses a Version 6 view descriptor with the Pass-Through Facility to access DBMS data. Beginning in Version 7, you can associate a libref directly with your DBMS data and use the ...