tarun1282

 Profile Answers by tarun1282 

• Apr 12th, 2006

 

hiselect b.first_name,b.salary,e.first_name,e.salaryfrom employees,(select first_name,salary from employees where first_name='Jones') bwhere e.salary>b.salary;

raj

• Apr 14th, 2006

 

select * from where more salary emp code=b

mannam07

 Profile Answers by mannam07 

• Jul 19th, 2007

 

 select a.ename,a.sal,b.ename,b.sal from emp a,emp  b where a.ename='CLARK' and
a.ename<>b.ename and a.sal<b.sal;

Vijay Krishnan

• Jul 20th, 2007

 

Try this
select b.sname,b.salary,a.sname,a.salary from sales b inner join sales a on a.sname = 'vijay' and b.salary > a.salary

venkat2182

 Profile Answers by venkat2182 

• Aug 9th, 2007

 

Hi....

I hope u know about "self-join". The following query will give the above result.


SELECT e1.name,e1.salary,e2.name,e2.salary FROM emp_test e1,emp_test e2
WHERE e1.name='Jones' FROM emp_test
AND e2.salary>e1.salary


Suppose u dont know who get min salary, u can use the following query,

SELECT e1.name,e1.salary,e2.name,e2.salary FROM emp_test e1,emp_test e2
WHERE e1.name=(SELECT name FROM emp_test WHERE salary=(SELECT Min(salary) FROM emp_test))
AND e2.salary>e1.salary

Imran_Javed

 Profile Answers by Imran_Javed 

• May 9th, 2008

 

SELECT
  e.ename || ' '|| e.sal || ' ' || e1.ename || ' '|| e1.sal
FROM
  EMP E ,
  emp e1
WHERE
  e.sal < e1.sal