How can i use select in SOQL query in Salesforce

Question

I am trying to run a select in Salesforce as follows:

     SELECT [Account].* FROM [Account] WHERE [Account].Id IN ('123456789012345678')

but gives an error: "Unknown error parsing query" How can i do this selection ?

Answer 1

SOQL is not the same as SQL. In Salesforce, the SQL syntax you're employing is invalid. The Write SOQL Queries unit on Trailhead or the SOQL and SOSL Reference can teach you the basics of SOQL.

There is no support for a SELECT * wildcard in Salesforce until the Spring '21 release. All fields must be fully stated. You'll be able to use FIELDS(ALL) once your organisation has upgraded to Spring '21 (the rollout is still in progress as of this writing). Your question would then be something like this:

SELECT FIELDS(ALL) FROM Account WHERE Id IN ('123456789012345678') 

 you must be using API version 51.0 to connect to Salesforce in order to use this function. You may return up to 200 records.

Elevate your career as a Salesforce Platform Developer with the industry-leading Salesforce Platform Developer1 Certification.