Scenario based question of the day || SOQL queries #salesforce #interview

[dineshsuthar]

Select Id from Account where Id IN (Select AccountId from contact where lastname='test contact')

[deepajs]

Select id, name, (select lastname, Accountid from contacts where lastname=‘Test contact’)from Account

[NeerajKumar-kqdl]

SELECT Id, Name
FROM Account
WHERE Id IN (SELECT AccountId FROM Contact WHERE LastName LIKE '%Test')

[rockingrafi.]

Select id from Account where Id IN (Select AccountId from Contact where LastName Like 'Test%')

[ukuleleguycs]

SELECT AccountId FROM Contact WHERE LastName = 'TestContact' AND AccountId != null GROUP BY AccountId

[hemantghaturkar]

Select id, name, (id from contact) from account where name='test')

[sanammulla]

SELECT AccountId, (SELECT LastName FROM Contacts WHERE LastName Like '%test Contact') FROM Account Ground By AccountId);

[surajbhalerao]

SELECT Id, name, (SELECT Lastname FROM contacts WHERE Lastname= ' Test contact')FROM Account

[satyam]

Select ID, name from account where I'd in:(select accountid from contact where lastname ='test contact')

[snehalnagmoti]

SELECT AccountId FROM Contact WHERE LastName = 'Test Contact' Group By AccountId

[arnabmukherjee]

Select Account.Name from Contact where lastname = 'test contact' group by Account.Name

[vishal_gadhave]

Select Account.name from contact where lastName ='test'

[mangeshumare]

Select Id, Name from Account WHERE Id IN ( Select AccountId From contact Where LastName LIKE 'test contact%')

[simmiagrawal]

SELECT Id, Name FROM Account WHERE Id IN ( SELECT AccountId FROM Contact Where AccountId != NULL AND LastName='test contact')

[RichLady]

Select id From Contact Where CreatedDate= LAST_N_MONTHS:6

[RohitYadav-bqxc]

[SELECT Id, (SELECT Id, LastName FROM Contacts)FROM Account WHERE LastName ='TestContact ']

[usharavi]

Select id, Name, (Select id, FirstName, LastName from contacts where LastName='Test Contact') From Account Where id IN(Select AccountId from contact where LastName='Test Contact')