Write SOQL query to print all Opportunity names that were won in the last and current quarter with their Account name and Opportunity Amount, ordered such that the largest Opportunity appears on the top (i.e., based on the Opportunity Amount).

Question

Ankaiah Bandi · Answer

Hi Suresh,

try with below query.

Select id, Name, Amount, Account.Name from Opportunity where (CreatedDate = LAST_QUARTER AND CreatedDate=THIS_QUARTER AND ISWon=true) ORDER BY Amount DESC

If this helps, Please mark it as best answer.

Thanks!!

Write SOQL query to print all Opportunity names that were won in the last and current quarter with their Account name and Opportunity Amount, ordered such that the largest Opportunity appears on the top (i.e., based on the Opportunity Amount).

Trailhead

Aprendizaje relacionado

Más ayuda