Salesforce Developer Tutorial - The Complete Guide to SOQL and SOSL in 2022! 

Another helpful SOQL function is FORMAT(). If you wrap a currency, number, or date,/time field with it, it will make those fields more reader-friendly. For instance, it will add the currency denomination ($) and delimiters (eg, 45000000 >>> $45,000,000): *SELECT Id, Name, FORMAT(Amount) FROM Opportunity*. You can also use it with aggregate queries: *SELECT FORMAT(MAX(Amount)) FROM Opportunity*.

Great video! Just a quick comment in reference to something you said at 45:35 in the video. In fact, the ORDER BY clause _will_ order the records by a field that is _not_ selected. For instance, the following SOQL query will organize the returned rows by last name even though LastName is not part of the SELECT clause: *SELECT Id, Name FROM Contact ORDER BY LastName*

Excellent content, i loved it. Thank you! please do cover more on LWC stuff!

Thanks, it's impressive that you can maintain for so long. I had to digest it in three sessions!

Thanks for the video, I found it very interesting.

Great content. Would love to learn more about the Async queries :).

Cool video, thank you for explaining the difference between SAQL and SOQL.

Thanks for providing this! Incredibly helpful content. Also, you kind of sound like Michael J Fox in Back to the Future.

One thing I was hoping to see but didn't: how to work with the outputs of sub queries returning more than one object in apex. You showed how a regular query or one that uses parent fields can be put right into a list, but I didn't see anything about the more complex types of results in apex.

Thank you this is helpful !

Thank you for this great video. One comment about lookup SOQL query from parent to child. If its custom object then Child Relationship Name which is available in UI , has to be appended with __r when you query, right?

Hello you are great and your lessons great too thank you for all of the hardwork.Even when my query is correct, it's underlined in red, and it's driving me crazy. What can we do about this issue? I bought Intellij with your advice. But I guess the system there is not the same as in the developer console. I can't reach some of the things that I can reach in developer consel, I guess because I don't know how to use intejij.

Thanks.. It is really a reference tutorial. ::: + :)

please guide me best salesforce text in amazon