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?



April 04, 2006 16:56:42 #1
 vijay Jaiswal   Member Since: Visitor    Total Comments: N/A 
RE: what is the difference between ALL and ANY in ORAC...
 

ANY
The If any value  from outcome of subquery is macthed then desired output will be retrived.It checks with lowest value .

ALL
Itwill check for greatest value from outcome of subquery

 

 
     

 

Back To Question