Ep - 4 | Salesforce SOQL Interview Question for Salesforce Developers | Practical SOQL - Part 2

[@cybergeek4545]

Thank You Ankit! Great help.

[@AnkitSalesforce]

Glad I could help you :)

[@DheerajSingh-us9nj]

it was more than just helpful..

[@AnkitSalesforce]

Thank you, I’m happy that you found it helpful

[@suryanshgupta5767]

Very informative and insightful. It will be great if you can cover rest of the questions. Appreaciate all the effort.🙌

[@AnkitSalesforce]

Thank you, I will

[@madhumohan2952]

for 11th question:
I still have a doubt with 11th que:
select id , name , (select id , name from opportunities where stagename='closed won') from Account
SELECT id , name from account where id in(select accountid from opportunity where stagename = 'closed won')
select account.name , accountid from Opportunity where stagename = 'Closed Won'
I think 2nd approach in this also works right ?
Can some one please help me in understanding this

[@AnkitSalesforce]

Right, Both the approaches are correct

[@madhumohan2952]

@@AnkitSalesforce so all the 3 approaches which I have commented will work right?

[@AnkitSalesforce]

@@madhumohan2952 Right, all three of them will work. The last one is querying opps instead of account. Thats the only difference

[@RishabhSharma-kq8go]

I feel the solution for the 11th question will be
SELECT Id, Name FROM Account WHERE Id IN ( SELECT AccountId FROM Opportunity WHERE StageName = 'Closed Won' )