HardCORE QUERY HELP!!!

From: Metnetsky <matt(at)uberstats(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: HardCORE QUERY HELP!!!
Date: 2003-03-02 04:20:29
Message-ID: hOednbvBOI8QG_yjXTWcqQ@giganews.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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);

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Bruno Wolff III 2003-03-02 04:46:43 Re: Dynamic SELECT condition
Previous Message Bruno Wolff III 2003-03-02 03:44:36 Re: Any limitation in size for return result from SELECT?