Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: group functions

Re: group functions

From: hpuxrac <johnbhurley_at_sbcglobal.net>
Date: 3 Dec 2006 11:29:20 -0800
Message-ID: <1165174160.882611.124690@73g2000cwn.googlegroups.com>

BigLearner wrote:
> Dear Budiess,
>
> Another doubt from group functions.
>
> EMPNO ENAME JOB MGR HIREDATE SAL COMM DEPTNO
> ------------ ------------ ------------------ --------
> ----------------- ------- ----------- -------------
> 7369 SMITH CLERK 7902 17-DEC-80 800
> 20
> 7499 ALLEN SALESMAN 7698 20-FEB-81 1600 300 30
> 7521 WARD SALESMAN 7698 22-FEB-81 1250 500 30
> 7566 JONES MANAGER 7839 02-APR-81 2975 20
> 7654 MARTIN SALESMAN 7698 28-SEP-81 1250 1400 30
> 7698 BLAKE MANAGER 7839 01-MAY-81 2850 30
> 7782 CLARK MANAGER 7839 09-JUN-81 2450 10
> 7788 SCOTT ANALYST 7566 09-DEC-82 3000 20
> 7839 KING PRESIDENT 17-NOV-81 5000
> 10
> 7844 TURNER SALESMAN 7698 08-SEP-81 1500 0 30
> 7876 ADAMS CLERK 7788 12-JAN-82 1100 20
> 7900 JAMES CLERK 7698 03-DEC-81 950
> 30
> 7902 FORD ANALYST 7566 03-DEC-81 3000 20
> 7934 FILLER CLERK 7782 23-JAN-82 1300
> 10
>
> Which of the following choices identifies the value tha would be
> returned from the following query: select sum(sal) + sum(comm) from emp
> where job = 'ANALYST' or ename like 'J%'?
>
> A. 6000
> B. 9925
> C. 9975
> D. NULL
>
> Which of the following choices identify the value returned by Oracle
> whn you issue the following query : select * from emp where hiredate >
> '23-JAN-82'? (Choose two.)
> A. ADAMS
> B. MILLER
> C. SCOTT
> D. SMITH
>
> I got these answers wrong so thought of asking you guys if you know the
> right answer.

Why don't you talk to the person that is teaching the class? Received on Sun Dec 03 2006 - 13:29:20 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US