GeekInterview.com
   Home |  Tech FAQ  |   Interview Questions |  Placement Papers |  Tech Articles |  Learn |  Freelance Projects |  Online Testing |  Geeks Talk |  Job Postings |  Knowledge Base | Site Search |  Add/Ask Question

  GeekInterview.com  >  Tech FAQs  >  Oracle

 Print  |  
Question:  what is the difference between ALL and ANY in ORACLE?
can any one explain with example?



November 11, 2007 07:33:19 #3
 rajakumar_na   Member Since: November 2007    Total Comments: 25 
RE: what is the difference between ALL and ANY in ORAC...
 
ANY and ALL are Multiple row operators.
<ANY - Less than the Maximum
>ANY - Greater than the Minimum
<ALL - Less than the Minimum
>ALL - Greater than the maximum 
     

 

Back To Question