jeffreyjane's Profile User Rating: -----

Reputation: 0 Apprentice
Group:
New Members
Active Posts:
6 (0.01 per day)
Joined:
08-August 12
Profile Views:
298
Last Active:
User is offline Aug 12 2012 08:08 PM
Currently:
Offline

Previous Fields

Dream Kudos:
0
Icon   jeffreyjane has not set their status

Posts I've Made

  1. In Topic: getting highest paid employee and lowest paid employee using pl/sql

    Posted 10 Aug 2012

    hi sir.. how about getting the highest and lowest paid employee each month?.

    i have the query like this:

    select hiredate, max(sal) highest_salary, min(sal)lowest_salary from temp3_emp
    	group by hiredate;
    


    but the output is:
    OUTPUT:
    HIREDATE HIGHEST_SALARY LOWEST_SALARY
    -------------------- -------------- -------------
    JAN-01-2012 14:23:01 2850 800
    APR-01-2012 14:23:01 1100 1100
    NOV-01-2012 14:23:01 1250 1250
    OCT-01-2012 14:23:01 2975 2975
    MAR-01-2012 14:23:01 950 950
    SEP-01-2012 14:23:01 1250 1250
    AUG-01-2012 14:23:01 2450 2450
    JUL-01-2012 14:23:01 3000 3000
    JUN-01-2012 14:23:01 5000 5000
    MAY-01-2012 14:23:01 1500 1500
    FEB-01-2012 14:23:01 3000 1300

    but based on the instruction, i have to display also the ename, hiredate of each month and the highest and lowest salary..

    what are the missing parameters?.

    thanks.. :)
  2. In Topic: getting highest paid employee and lowest paid employee using pl/sql

    Posted 9 Aug 2012

    hi good day!

    i just wanna ask how to get the highest and lowest paid employee from temp3_emp table. i have here the codes:

    select ename, sal from temp3_emp
    	where sal = (select max(sal)highest_paid from temp3_emp) or sal = (select min(sal)least_paid from temp3_emp);
    


    but then, i only get the names and the salary.. wherein, i have to declare who is the highes paid employee and the lowest paid employee..

    here's the output:

    ENAME SAL
    ---------- ----------
    SMITH 800
    KING 5000

    any one who can help?. thanks a lot.. :)
  3. In Topic: hi.. oracle programming

    Posted 8 Aug 2012

    sir, what are the difference of oracle 11g and oracle? thanks..

    anyways, i got the.. :)
  4. In Topic: hi.. oracle programming

    Posted 8 Aug 2012

    hi.. so far, this is my code for the output;

     select 'My name is a ' || ename, 'and I am a ' || job from emp
      where JOB <> 'ANALYST'
      or 'My name is a' || ename 'and I am an ' || job
      where JOB = 'ANALYST';
    


    but then i still have errors like this..


    or 'My name is a' || ename 'and I am an ' || job
    *
    ERROR at line 3:
    ORA-00920: invalid relational operator

    please help me for further changes, so i can execute my codes.. thanks..

    by the way, i am using oracle 11g..

    good day!

My Information

Member Title:
New D.I.C Head
Age:
Age Unknown
Birthday:
Birthday Unknown
Gender:

Contact Information

E-mail:
Click here to e-mail me

Friends

jeffreyjane hasn't added any friends yet.

Comments

jeffreyjane has no profile comments yet. Why not say hello?