function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
Here I amHere I am 

What is difference between SOQL and SOSL?

What is difference between SOQL and SOSL?
Best Answer chosen by Here I am
PERFECTIONISTPERFECTIONIST
SOQL:
1) SOQL (Salesforce Object Query Language ) retrieves the records from the database by using “SELECT” keyword.
2) By Using SOQL we can know in Which objects or fields the data resides.
3) We can retrieve data from single object or from multiple objects that are related to each other.
4) We can Query on only one table.
SOSL:
1) SOSL(Salesforce Object Search Language) retrieves the records from the database by using the “FIND” keyword.
2) By using SOSL, we don’t know in which object or field the data resides.
3) We can retrieve multiple objects and field values efficiently when the objects may or may not be related to each other.
4) We can query on multiple tables.

 

All Answers

PERFECTIONISTPERFECTIONIST
SOQL:
1) SOQL (Salesforce Object Query Language ) retrieves the records from the database by using “SELECT” keyword.
2) By Using SOQL we can know in Which objects or fields the data resides.
3) We can retrieve data from single object or from multiple objects that are related to each other.
4) We can Query on only one table.
SOSL:
1) SOSL(Salesforce Object Search Language) retrieves the records from the database by using the “FIND” keyword.
2) By using SOSL, we don’t know in which object or field the data resides.
3) We can retrieve multiple objects and field values efficiently when the objects may or may not be related to each other.
4) We can query on multiple tables.

 
This was selected as the best answer
kuldeep paliwalkuldeep paliwal
SOQL(Salesforce Object Query Language)SOSL(Salesforce Object Search Language)
Only one object at a time can be searched(Search in Single object)Many object can be searched at a time(Search in entire organization or Database)
Query all type of fieldQuery on only email, text or phone
It can be used in classes n triggersIt can use in classes but not in trigger
DML Operation can be performed on query resultsDML Operation cannot be performed on search results
Return RecordsReturn Field