There are basically two types of SOQLs in Salesforce:
- Static SOQL : It is written like an IINQ (Ion Integrated Query) using [] (array brackets)
- Dynamic SOQL : It is appropriate for using Apex code to refer to the SOQL string creation during runtime.