PMS Information Systems
Welcome to PMS Information Systems - IBM i (AS/400) Forum !!!

Get Answers for all your queries on IBM i (AS/400).

Join the forum, it's quick and easy

PMS Information Systems
Welcome to PMS Information Systems - IBM i (AS/400) Forum !!!

Get Answers for all your queries on IBM i (AS/400).
PMS Information Systems
Would you like to react to this message? Create an account in a few clicks or log in to continue.

ALL about AS/400

Final Year Projects: PMS Academy guides for the Final Year IEEE / Real Time Projects for Academics.

SQL TIP: VALUES CLAUES CAN BE USED TO ENCAPSULATE SEVERAL INDEPENDENT QUERIES

PMS Information Systems :: IBM i (AS/400) Programmers :: DB2 Admin & Programming

Go down

SQL TIP: VALUES CLAUES CAN BE USED TO ENCAPSULATE SEVERAL INDEPENDENT QUERIES Empty SQL TIP: VALUES CLAUES CAN BE USED TO ENCAPSULATE SEVERAL INDEPENDENT QUERIES

Post  maran Mon May 16, 2016 10:42 pm

SQL TIP: VALUES CLAUES CAN BE USED TO ENCAPSULATE SEVERAL INDEPENDENT QUERIES

EXAMPLE:
VALUES (( SELECT COUNT(*) FROM EMPLOYEE),
       ( SELECT AVG(EMPSAL) FROM SALARY),
       ( SELECT MAX(DEPCDE) FROM DEPT))
maran
maran
Admin

Posts : 442
Join date : 2009-07-24

https://pmsinformationsystem.forumotion.net

Back to top Go down

Back to top

- Similar topics

PMS Information Systems :: IBM i (AS/400) Programmers :: DB2 Admin & Programming

 
Permissions in this forum:
You cannot reply to topics in this forum