Question

Locked

oracle subquery

By sauravbhattacharjee ·
difference in using any and all while executing a subquery?

This conversation is currently closed to new comments.

3 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Answers

Collapse -

Any

by Tony Hopkinson In reply to oracle subquery

returns true if the where clause will return a record, All returns false if any one of them doesn't

So it you had 10,20,30 in a table
Any < 20 would return true
All < 20 would return false

...

Collapse -

question on oracle

by sauravbhattacharjee In reply to oracle subquery

if an aggregate function is used in original query supported by a group by clause then whether the group by clause will be used if we use the aggregate function in a co-related
subquery?

Collapse -

Reponse To Answer

by Tony Hopkinson In reply to question on oracle

Can't see how, Aggregation and grouping are after selection, that' why you have to select all the fields you are grouping by.

Back to IT Employment Forum
3 total posts (Page 1 of 1)  

Related Discussions

Related Forums