Home » SQL & PL/SQL » SQL & PL/SQL » sql help
sql help [message #218930] Mon, 12 February 2007 02:42 Go to next message
pavuluri
Messages: 247
Registered: January 2007
Senior Member

what is difference any,all,some operators
Thanks,
srinivas
Re: sql help [message #218944 is a reply to message #218930] Mon, 12 February 2007 03:23 Go to previous messageGo to next message
pavuluri
Messages: 247
Registered: January 2007
Senior Member
SEE THIS

select sal from EMP where sal > (select min(sal) from emp where job ='SALESMAN');

SELECT sal from EMP where sal > any(select sal from emp where job='SALESMAN')

its giving same result

select sal from EMP where sal < (select min(sal) from emp where job ='SALESMAN');

select sal from EMP where sal < (select min(sal) from emp where job ='SALESMAN');

its not giving same result.

why?




Re: sql help [message #218945 is a reply to message #218944] Mon, 12 February 2007 03:26 Go to previous message
pavuluri
Messages: 247
Registered: January 2007
Senior Member
sorry
select sal from EMP where sal < (select min(sal) from emp where job ='SALESMAN');

select sal from EMP where sal < any (select min(sal) from emp where job ='SALESMAN');

its not giving same result.

Previous Topic: Export BLOB data
Next Topic: PL/SQL struck in the way need some help
Goto Forum:
  


Current Time: Thu Dec 08 06:13:44 CST 2016

Total time taken to generate the page: 0.06114 seconds