What are the Applications of Nested Query in Salesforce?

Hello Chanchal,

Application of Nested Query:-

1. For example, you implemented a trigger on Contact, but you want to access account, the nested query can help you and vice versa.
2.  Finding Second MAX or Second MIN Salary, you have to use the nested query.
3. GROUP BY clause generally implemented on Nested Query.

These are the small scenarios, which I know, there is a lot more - application of nested query.

Thanks.