Skip to main content
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).
1 件の回答
  1. 2022年11月6日 20:29
    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!!​​​​​​​
0/9000