What Are The Types of SOQL Statements in Salesforce?

Hello,

Salesforce Object Query Language is used to query that records from the database.com based on the requirement.
There are 2 types of SOQL Statements.

Static SOQL
Dynamic SOQL

1.Static SOQL: The oStatic SOQL Statement is written in []  (Array Brackets)
This statements are similar to IINQ(Ion Integrated Query)
Example: String search for =’Jones’;
Contact[] contacts=[select testfield__c, FirstName, LastName from Contact Where Last Name=:search for];

2. Dynamic SOQL: 

It is used to refer to the creation of a SOQL string at run time with Apex code.
Dynamic SOQL enables you to create more flexible application.
To create Dynamic SOQL query at run time use Database.Query() method, in one of the following ways.
Return a single sObjects when the query returns a single record.
sObjects s = Database. Query(String_limit_l);
Return a list of sObjects when the query returns more than a single record.
Examples:
Eg1:
String myTestString = ‘TestName’;
List List= Database.Query(SELECT Id FROM MyCustomObject__c WHERE Name = :myTestString);
Eg2:
String resolviedfield L = myvariable.field__c;
List L = Database.Query(‘SELECT Id FROM myCustomObject__c WHERE field__c = ‘+resolvedfield_L);

There are 2 types of SOQL Statements.

Static SOQL:

Static SOQL means you are using some SOQL with any user input or hard code values like below query view source
List<Account> lstAccount = [select id,name form account where name ='Amit'];

Dynamic SOQL:

Dynamic SOQL refers to the creation of a SOQL string at runtime with Apex code. Dynamic SOQL enables you to create more flexible applications. For example, you can create a search based on input from an end user, or update records with varying field names. This is the major difference between SOQL and dynamic SOQL.

Dynamic query looks like this...
List<sObject> L = Database.query(string);

Thanks