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..

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..

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

anyways, i got the..

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!