how to identify the last modified Opportunity from list of Opportunities under associated Account considering last modified date and time using apex coding
select Id, Name, (select Id, Name, LastModifiedDate from Opportunities order by LastModifiedDate DESC)
from Account
where Name = "OpFocus"
The query above gets you a list of Accounts matching the given criteria. For each Account, it lists the Account's Opportunities, with the most recently modified Opportunity given first. This works well if your criteria could match more than one Account.
select Id, Name, LastModifiedDate
from Opportunity
where Account.Name = 'OpFocus'
order by LastModifiedDate DESC
limit 1
This query gets you just the most recently modified Opportunity that belongs to the Account, assuming that there's only one Account that matches the given criteria.
The query above gets you a list of Accounts matching the given criteria. For each Account, it lists the Account's Opportunities, with the most recently modified Opportunity given first. This works well if your criteria could match more than one Account.
This query gets you just the most recently modified Opportunity that belongs to the Account, assuming that there's only one Account that matches the given criteria.