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

Hi! I am Ankit, I have 5+ years of working experience with product-based companies, including Salesforce.
Getting into Salesforce isn't easy, so here I am to help you in your Salesforce journey.
In this video, we will discuss SOQL Salesforce interview questions asked in many companies.
Watch till the end to find out the solution to the problem. If you have any queries - please do comment down below!

[@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' )