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
prathap cprathap c 

What is the difference between SQL and SOQL?

can any one expalin?
Suneel#8Suneel#8
SQL is used for getting data from one or more tables.They can be either related or not
SOQL is used for getting the data of a particular object and its related objects.You cannot pull data of two un related objects through SOQL.Please read following link for more details and syntax

https://developer.salesforce.com/page/A_Deeper_look_at_SOQL_and_Relationship_Queries_on_Force.com
sfdc550sfdc550

SQL is standard ANSI  standard query language where as SOQL is specially optimized version of SQL specially designed for working with Salesforce.com underlying database. it is the abbreviation of Salesforce Object Query Language.

In addition, SOQL does not support very advance level SQL specific functions like using wild cards, join operations etc...



You can refer to these links for a better understanding of SOQL:

http://www.salesforce.com/us/developer/docs/api/Content/sforce_api_calls_soql.htm

http://wiki.developerforce.com/page/A_Deeper_look_at_SOQL_and_Relationship_Queries_on_Force.com
 
Sai Ram ASai Ram A
Hello Prathap

A quick view for you, also recommend to go through with the Links our Suneel & all550 have Shared
User-added image

Thank you
BLearn
NAVEEN KUMARNAVEEN KUMAR
SQL Is a Query Language to retrive data on Relational Database(Oracle,My SQL).
SOQL is a  Query Language to retrive data from salesforce objects.
Data Loader 5Data Loader 5
Check this article to learn the difference in syntax between SOQL and SQL - https://skyvia.com/blog/soql-vs-sql-best-practices-to-query-salesforce-database