Question Locked
0 helpful
4 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
difference in using any and all while executing a subquery?
4 replies
by sauravbhattacharjee Accepted solution
Clarifications
by tony hopkinson Accepted solution
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
...
by sauravbhattacharjee Accepted solution
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?
by tony hopkinson Accepted solution
Can't see how, Aggregation and grouping are after selection, that' why you have to select all the fields you are grouping by.
This discussion is closed to new replies.
Trending IT Employment posts
Sort by Trending
0 helpful
2 replies
0 helpful
11 replies
0 helpful
1 reply
0 helpful
6 replies
Discussion Locked
How should organizations verify AI generated information before using it
0 helpful
0 replies