A Simple Beginner’s Problem from a Swedish Student

Question:
Facts: Employee(name,salary,boss,department)

Question: Which employees earn more than their boss ?

Answer:
Please make sure you don’t share the results with your boss! : )

Try the following:

use pubsgocreate table myemployee( name char(30),  salary int,  boss char(30),  department char(15),  constraint pk_employee primary key(name)) goinsert into myemployee (name,salary,boss,department)values ('FRANK',50000,'FRANK','ACCOUNTING')insert into myemployee (name,salary,boss,department)values ('JIM',40000,'FRANK','ACCOUNTING')insert into myemployee (name,salary,boss,department)values ('JOE',70000,'FRANK','ACCOUNTING')insert into myemployee (name,salary,boss,department)values ('HARRY',80000,'HARRY','MIS')insert into myemployee (name,salary,boss,department)values ('TIM',45000,'HARRY','MIS')insert into myemployee (name,salary,boss,department)values ('TOM',90000,'HARRY','MIS')select e.name as 'Employee', e.salary as 'Employee Salary', boss.name as 'Boss',    boss.salary as 'Boss Salary'from myemployee e, myemployee bosswheree.boss = boss.name ande.salary > boss.salary

Share the Post:
Share on facebook
Share on twitter
Share on linkedin

Overview

Recent Articles: