Posted by: Stiffler October 18, 2010
Login in to Rate this Post:
0 
? 
?
First off, I learned sql on my own 8 yrs back and never used it so my memory is not fresh.
Second, if you cannot do this simple problem then forget about graduating with good gpa, and don't blame it on USA when u don't get a job after graduating. Alikati ta afai padhnu payo ni som.
Select fname, lname
From employee
Where salary>( (select min(salary) from employee)+10000);
2. Select fname, lname
From employee
Where dno=(select dno from employee where salary=(select max(salary) from employee));
Second, if you cannot do this simple problem then forget about graduating with good gpa, and don't blame it on USA when u don't get a job after graduating. Alikati ta afai padhnu payo ni som.
Select fname, lname
From employee
Where salary>( (select min(salary) from employee)+10000);
2. Select fname, lname
From employee
Where dno=(select dno from employee where salary=(select max(salary) from employee));