HardCORE QUERY HELP!!!
От | Metnetsky |
---|---|
Тема | HardCORE QUERY HELP!!! |
Дата | |
Msg-id | hOednbvBOI8QG_yjXTWcqQ@giganews.com обсуждение исходный текст |
Ответы |
Re: HardCORE QUERY HELP!!!
Re: HardCORE QUERY HELP!!! |
Список | pgsql-sql |
Q: list employee name, job, manager name and salary for those whose salary is more than their manager The quetion may seem kinda dumb, it's for a class and my professor has a thing for brain teaser type questions. I attempted doing this with rename and a natural join but I can't get the rename to work I think. Any help would be much appreciated. Thanx Table Definition: create table emp (empno numeric(4) not null, ename varchar(10) not null, job varchar(10) not null, mgr numeric(4), hiredate date, sal numeric(6) not null, comm numeric(4), deptno numeric(4) not null, primary key(empno)); Example Data: values(7369,'Martinez','Clerk',7902,'1990-12-17',2800,null,20); values(7499,'Jeter','Sales',7698,'1991-02-20',3600,1300,30); values(7521,'Knoblauch','Sales',7698,'1998-02-22',3250,1500,30); values(7566,'Torre','Manager',7839,'1991-04-02',4975,null,20); values(7654,'Strawberry','Sales',7698,'1994-09-28',2250,2400,30);values(7698,'Dimago','Manager',7839,'1995-05-01', 4850,null,30); values(7782,'Williams','Manager',7839,'1997-06-09',4450,null,10);
В списке pgsql-sql по дате отправления: