Static SOQL is one which you write in square brackets. It is good to use when you didn’t have any dynamic changes in the soql query. For e.g when the fields names or where conditions is needed to be defined dynamically we didn’t use statis soql. Then we need to use dynamic soql. Dynamic SOQL is dynamic query creation.